Postgres Pro
Downloads
Home   >   mailing lists

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

From Alexander Farber
Subject Re: How to add "on delete cascade" constraints
Date
Msg-id CAADeyWj39-UDs2pKjibb0a+V1m8NMQSynZVUuNuqL6_-EZBgOA@mail.gmail.com
Whole thread Raw
In response to Re: How to add "on delete cascade" constraints  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: How to add "on delete cascade" constraints  (Raymond O'Donnell <rod@iol.ie>)
Re: How to add "on delete cascade" constraints  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-general
Tree view 
So it's not a problem to drop and recreate the FOREIGN KEYs?

And can I use START TRANSACTION while doing it?

On Fri, Apr 27, 2012 at 9:30 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> On 27/04/2012 19:59, Alexander Farber wrote:
>> 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.

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: How to add "on delete cascade" constraints
Next
From: "J.V."
Date:
Subject: how to execute a stored function that returns a boolean?