Postgres Pro
Downloads
Home   >   mailing lists

Re: issue about information_schema REFERENTIAL_CONSTRAINTS - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: issue about information_schema REFERENTIAL_CONSTRAINTS
Date
Msg-id 1283438419.23199.0.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: issue about information_schema REFERENTIAL_CONSTRAINTS  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: issue about information_schema REFERENTIAL_CONSTRAINTS  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-bugs
Tree view 
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?

pgsql-bugs by date:

Previous
From: Anderson Costa
Date:
Subject: Dúvida
Next
From: Tom Lane
Date:
Subject: Re: BUG #5636: extra "(" or missing ")"