Re: issue about information_schema REFERENTIAL_CONSTRAINTS

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Date: 2010-09-02 14:40:19
Message-ID: 1283438419.23199.0.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

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?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-09-02 14:48:04 Re: BUG #5636: extra "(" or missing ")"
Previous Message Anderson Costa 2010-09-02 13:50:37 Dúvida

Browse pgsql-docs by date

  From Date Subject
Next Message Fabien COELHO 2010-09-02 18:34:46 Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Previous Message Thom Brown 2010-09-02 08:33:01 Re: Inconsistent index links