Re: drop/add fk in transaction - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: drop/add fk in transaction
Date
Msg-id 20030813173236.Y63884-100000@megazone.bigpanda.com
Whole thread Raw
In response to drop/add fk in transaction  (Nabil Sayegh <postgresql@e-trolley.de>)
Responses Re: drop/add fk in transaction
List pgsql-novice
On 14 Aug 2003, Nabil Sayegh wrote:

> I want to convert a database from 7.2 RI to 7.3 RI
> I need to drop 165 RI_ConstraintTrigger and
> add 55 7.3-style foreign keys.
>
> Is it possible to do all that in a transaction ?

It should be fine I think barring that you probably
don't want other transactions going on that might
touch those tables concurrently because you're going
to be grabbing exclusive locks on a bunch of tables
and you want to make sure you don't deadlock with
some other transaction.



pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: drop/add fk in transaction
Next
From: Nabil Sayegh
Date:
Subject: Re: drop/add fk in transaction