pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: PostgreSQL Bugs List <pgsql-bugs@postgresql.org>
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Date: Fri, 3 Sep 2010 19:39:19 +0200 (CEST)
Message-ID: <alpine.DEB.2.00.1009031920460.2622@localhost.localdomain> (raw)
In-Reply-To: <22801.1283525905@sss.pgh.pa.us>
References: <alpine.DEB.2.00.1008311337530.2449@localhost.localdomain>
	<2683.1283266019@sss.pgh.pa.us>
	<alpine.DEB.2.00.1009011557480.2570@localhost.localdomain>
	<1283369900.15386.0.camel@vanquo.pezone.net>
	<alpine.DEB.2.00.1009020741380.2656@localhost.localdomain>
	<1283438419.23199.0.camel@vanquo.pezone.net>
	<alpine.DEB.2.00.1009021959070.2656@localhost.localdomain>
	<6462.1283454730@sss.pgh.pa.us>
	<alpine.DEB.2.00.1009031348321.2448@localhost.localdomain>
	<22801.1283525905@sss.pgh.pa.us>


>> 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.



view thread (33+ messages)  latest in thread

Message-ID: <alpine.DEB.2.00.1009031920460.2622@localhost.localdomain>
Permalink:  ../alpine.DEB.2.00.1009031920460.2622@localhost.localdomain/
Also on:    postgresql.org/message-id/alpine.DEB.2.00.1009031920460.2622@localhost.localdomain

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: coelho@cri.ensmp.fr, tgl@sss.pgh.pa.us, peter_e@gmx.net, pgsql-bugs@postgresql.org
  Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
  In-Reply-To: <alpine.DEB.2.00.1009031920460.2622@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox