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.1009031920460.2622@localhost.localdomain
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  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-bugs
>> Well, one must choose between to evil:
>
> Yeah, exactly.  I think that the current tradeoff is just fine.

Hmmm. I think exactly the contrary. There is no point in having a non
reliable feature.

ISTM that very few people use the information schema, and if the query
results is not reliable, it will stay this way. If you have zero user, no
one will complain, which prooves that everything is fine:-) QED.

By the way, do you use the information schema?


> If you want SQL-standard behavior, pick SQL-standard constraint names,
> and there you are.

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.


Could you register this "bug" somewhere please?

Thanks for your time.

--
Fabien.

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Next
From: Alvaro Herrera
Date:
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS