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

From Kevin Grittner
Subject Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Date
Msg-id 4C80CA8B020000250003517B@gw.wicourts.gov
Whole thread Raw
In response to Re: issue about information_schema REFERENTIAL_CONSTRAINTS  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: issue about information_schema REFERENTIAL_CONSTRAINTS  (Fabien COELHO <fabien.coelho@ensmp.fr>)
List pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Yeah, exactly.  I think that the current tradeoff is just fine.
> If you want SQL-standard behavior, pick SQL-standard constraint
> names, and there you are.

I see that as the crux if it -- the current implementation *allows*
standard-conforming behavior, even though it doesn't *enforce*
conforming naming.  The proposed alternative does not allow
standard-conforming behavior.  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.

-Kevin

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Next
From: Fabien COELHO
Date:
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS