Postgres Pro
Downloads
Home   >   mailing lists

Re: How to add "on delete cascade" constraints - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: How to add "on delete cascade" constraints
Date
Msg-id 4F9AF3BE.5040404@iol.ie
Whole thread Raw
In response to How to add "on delete cascade" constraints  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: How to add "on delete cascade" constraints
List pgsql-general
Tree view 
On 27/04/2012 19:59, Alexander Farber wrote:
> Hello,
>
> in 8.4.9 is it please possible to add "on delete cascades" to
> the both foreign keys in the following table w/o dropping the table?

I think you will have to drop the foreign key and re-create it, but
certainly not the table.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: How to add "on delete cascade" constraints
Next
From: Alexander Farber
Date:
Subject: Re: How to add "on delete cascade" constraints