Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 04E1E632306 for ; Wed, 1 Sep 2010 16:38:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 30381-08 for ; Wed, 1 Sep 2010 19:38:23 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.23]) by mail.postgresql.org (Postfix) with SMTP id 7443D632AF0 for ; Wed, 1 Sep 2010 16:38:23 -0300 (ADT) Received: (qmail invoked by alias); 01 Sep 2010 19:38:21 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp011) with SMTP; 01 Sep 2010 21:38:21 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18fQrJwMJUfFtqhIiSuLH9AxZeoBIGVHFlfjHkVnH EsJaxhajzcHQ9Q Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS From: Peter Eisentraut To: Fabien COELHO Cc: Tom Lane , PostgreSQL Bugs List In-Reply-To: References: <2683.1283266019@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Date: Wed, 01 Sep 2010 22:38:20 +0300 Message-ID: <1283369900.15386.0.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.30.2 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/3 X-Sequence-Number: 27967 On ons, 2010-09-01 at 16:22 +0200, Fabien COELHO wrote: > I'm suggesting uniqueness in the "information_schema", which can be > provided independently by some tweaking in the view construction, I > think, for instance by adding the oid of the constraint or maybe the > table_name. The view is defined by the SQL standard. We cannot change it.