Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5A5F46329B6 for ; Thu, 2 Sep 2010 11:40:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 17059-05 for ; Thu, 2 Sep 2010 14:40:26 +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 A3917632957 for ; Thu, 2 Sep 2010 11:40:25 -0300 (ADT) Received: (qmail invoked by alias); 02 Sep 2010 14:40:22 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp013) with SMTP; 02 Sep 2010 16:40:22 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1/x0BNsre/xDP03jn5NnshZWZXGXtTxp1EwtwJpTh rK6XKiTwAWO0XP Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS From: Peter Eisentraut To: Fabien COELHO Cc: PostgreSQL Bugs List In-Reply-To: References: <2683.1283266019@sss.pgh.pa.us> <1283369900.15386.0.camel@vanquo.pezone.net> Content-Type: text/plain; charset="UTF-8" Date: Thu, 02 Sep 2010 17:40:19 +0300 Message-ID: <1283438419.23199.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/12 X-Sequence-Number: 27976 On tor, 2010-09-02 at 07:54 +0200, Fabien COELHO wrote: > > We cannot change it. > > Yes we can! It, it is 100% postgresql: > > \d information_schema.referential_constraints > View "information_schema.referential_constraints" > ... > FROM pg_namespace ncon > JOIN pg_constraint con ON ncon.oid = con.connamespace > JOIN pg_class c ON con.conrelid = c.oid Well, for the sake of argument, how would you propose to change it?