Postgres Pro
Downloads
Home   >   mailing lists

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

From Douglas McNaught
Subject Re: deleting the master but not the detail
Date
Msg-id 5ded07e00807170952m26a2fab1t738ad1a3842bae02@mail.gmail.com
Whole thread Raw
In response to deleting the master but not the detail  ("Ismael ...." <ismaelpsp@hotmail.com>)
Responses Re: deleting the master but not the detail
List pgsql-general
Tree view 
On Thu, Jul 17, 2008 at 12:11 PM, Ismael .... <ismaelpsp@hotmail.com> wrote:
>
> hi
> I have one of those master-detail relationships here and I need to be able
> to delete the master but leave the details untouched

Then remove the referential integrity constraint, since it's obviously
incompatible with your business requirements.

-Doug

pgsql-general by date:

Previous
From: "Ismael ...."
Date:
Subject: Re: deleting the master but not the detail
Next
From: "Scott Marlowe"
Date:
Subject: Re: query optimization