From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: drop/add fk in transaction |
Date: | 2003-08-14 00:36:05 |
Message-ID: | 20030813173236.Y63884-100000@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2003-08-14 00:36:11 | Re: drop/add fk in transaction |
Previous Message | Nabil Sayegh | 2003-08-14 00:09:36 | drop/add fk in transaction |
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2003-08-14 00:36:11 | Re: drop/add fk in transaction |
Previous Message | Nabil Sayegh | 2003-08-14 00:09:36 | drop/add fk in transaction |