| 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: | Whole Thread | Raw Message | 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 |