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

From Fabien COELHO
Subject Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Date
Msg-id alpine.DEB.2.00.1009031939250.2622@localhost.localdomain
Whole thread Raw
In response to Re: issue about information_schema REFERENTIAL_CONSTRAINTS  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: issue about information_schema REFERENTIAL_CONSTRAINTS  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
> If you're going to use something which is PostgreSQL-specific, you may
> as well write your own views or use the "native" tables and views
> directly.

I wish I could write portable code, if possible:-)

I'm basically writing views on top of the information_schema under the
assumption that what is expected to be a key is a key. The information
schema is *useless* otherwise as wrong tuples are built on join, and
derived information is not reliable.

I guess I must the only actual user of the information_schema, and it will
soon be back to zero user, which will be fine from the developers point of
view.

--
Fabien.

pgsql-bugs by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS (resent)
Next
From: Robert Haas
Date:
Subject: Re: BUG #5633: an empty row with null-like values in not-null field