Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: deleting a foreign key that has no references
Date
Msg-id 9e4684ce0703190851g17438842s31a2a7c154cc27e0@mail.gmail.com
Whole thread Raw
In response to deleting a foreign key that has no references  ("Glen W. Mabey" <Glen.Mabey@swri.org>)
Responses Re: deleting a foreign key that has no references  ("Glen W. Mabey" <Glen.Mabey@swri.org>)
List pgsql-general
Tree view 
On 3/19/07, Glen W. Mabey <Glen.Mabey@swri.org> wrote:
> But, really, I just want to be able to test to see how many references
> there are to a key.  Is there some way to do that?

write a triggers which do that.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Planner tuning
Next
From: "Glen W. Mabey"
Date:
Subject: Re: deleting a foreign key that has no references