Re: deleting the master but not the detail - Mailing list pgsql-general

From Stephan Szabo
Subject Re: deleting the master but not the detail
Date
Msg-id 20080717103731.T77268@megazone.bigpanda.com
Whole thread Raw
In response to Re: deleting the master but not the detail  ("Ismael ...." <ismaelpsp@hotmail.com>)
Responses Re: deleting the master but not the detail  ("Ismael ...." <ismaelpsp@hotmail.com>)
List pgsql-general
On Thu, 17 Jul 2008, Ismael .... wrote:

> So is there no other way to do it but to verify the integrity using triggers
> and drop the referential constraints?

Well, you could do something using a before delete trigger on the
referencing table that returns NULL to avoid the delete as well, but
making it only prevent the deletions caused by the referential constraints
might be difficult.

pgsql-general by date:

Previous
From: "Rhys A.D. Stewart"
Date:
Subject: in query variables....
Next
From: "Douglas McNaught"
Date:
Subject: Re: [HACKERS] postmaster.pid not visible