Postgres Pro
Downloads
Home   >   mailing lists

Re: deleting a foreign key that has no references - Mailing list pgsql-general

From Tom Lane
Subject Re: deleting a foreign key that has no references
Date
Msg-id 13751.1174323188@sss.pgh.pa.us
Whole thread Raw
In response to Re: deleting a foreign key that has no references  ("Glen W. Mabey" <Glen.Mabey@swri.org>)
Responses Insert fail: could not open relation with OID 3221204992  (araza@esri.com)
List pgsql-general
Tree view 
"Glen W. Mabey" <Glen.Mabey@swri.org> writes:
> What I'm hoping to find out is whether there is some way to directly
> find out how many (using a SELECT query) references there are to a key.

There's no hidden shortcut for that, no.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: deleting a foreign key that has no references
Next
From: "Jaroslav Záruba"
Date:
Subject: DBD:Pg for Windows (PostgreSQL+Perl)