Re: deleting the master but not the detail

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: "Ismael (dot)(dot)(dot)(dot)" <ismaelpsp(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: deleting the master but not the detail
Date: 2008-07-17 16:52:20
Message-ID: 5ded07e00807170952m26a2fab1t738ad1a3842bae02@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 17, 2008 at 12:11 PM, Ismael .... <ismaelpsp(at)hotmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2008-07-17 17:00:44 Re: deleting the master but not the detail
Previous Message A. Kretschmer 2008-07-17 16:51:59 Re: deleting the master but not the detail