From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: drop/add fk in transaction |
Date: | 2003-08-14 00:36:11 |
Message-ID: | 1060821370.4750.34.camel@billy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
Am Don, 2003-08-14 um 02.36 schrieb Stephan Szabo:
> 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.
The action should take only 2 seconds or so.
I think it would be ok for that case to lock everything :) while this
transaction is running.
Do you have a commandline by hand ?
Usually I would just do begin; ... end;
TFYH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
From | Date | Subject | |
---|---|---|---|
Next Message | Dustin Sallings | 2003-08-14 00:46:59 | Re: Support contracts (was Re: Commercial support?) |
Previous Message | Stephan Szabo | 2003-08-14 00:36:05 | Re: drop/add fk in transaction |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-08-14 02:23:58 | Re: drop/add fk in transaction |
Previous Message | Stephan Szabo | 2003-08-14 00:36:05 | Re: drop/add fk in transaction |