Postgres Pro
Downloads
Home   >   mailing lists

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

From Raymond O'Donnell
Subject Re: deleting the master but not the detail
Date
Msg-id 487F7ABC.1090604@iol.ie
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 17/07/2008 17:11, Ismael .... wrote:

> ON DELETE RESTRICT | NO ACTION won't let me delete the master
> CASCADE | SET NULL | SET DEFAULT will modify the details

Can you just drop the constraint that's doing the referential integrity?

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: deleting the master but not the detail
Next
From: "Ismael ...."
Date:
Subject: Re: deleting the master but not the detail