Re: issue about information_schema REFERENTIAL_CONSTRAINTS - Mailing list pgsql-bugs

From Tom Lane
Subject Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Date
Msg-id 26284.1283536406@sss.pgh.pa.us
Whole thread Raw
In response to Re: issue about information_schema REFERENTIAL_CONSTRAINTS  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: issue about information_schema REFERENTIAL_CONSTRAINTS
List pgsql-bugs
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Fabien COELHO's message of vie sep 03 13:39:19 -0400 2010:
>> I tried to explained that I'm analyzing other people's schemas. I cannot
>> ask all other people on the planet to rewrite their schemas, I pick them
>> as they are.

> Maybe you shouldn't be using the information_schema in the first place.

It would probably be reasonable to put something into chapter 34 of the
docs pointing out this limitation.  I'm not sure exactly where though.
Should we invent a "compatibility issues" section in that chapter,
analogous to the ones we have for individual SQL commands?  Are there
other issues worth documenting for the information_schema views?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Next
From: Fabien COELHO
Date:
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS