Re: How to add "on delete cascade" constraints

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to add "on delete cascade" constraints
Date: 2012-04-27 19:40:51
Message-ID: CAADeyWj39-UDs2pKjibb0a+V1m8NMQSynZVUuNuqL6_-EZBgOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J.V. 2012-04-27 19:43:19 how to execute a stored function that returns a boolean?
Previous Message Raymond O'Donnell 2012-04-27 19:30:06 Re: How to add "on delete cascade" constraints