| 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 10:21:57 |
| Message-ID: | 1060856517.10271.3.camel@billy |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
Am Don, 2003-08-14 um 04.23 schrieb Stephan Szabo:
> > The action should take only 2 seconds or so.
>
> Do you have data in the tables? Because if you're planning
> to use ALTER TABLE ADD CONSTRAINT to add the new version
> constraints it's going to check that the constraint is
> satisified (and that can be not so fast).
I already tried that with some less important databases and it took
about 2 seconds.
The DBs aren't that big and the machine is quite fast :)
> > I think it would be ok for that case to lock everything :) while this
> > transaction is running.
> >
> > Do you have a commandline by hand ?
>
> I'd look at contrib/adddepend which I think does some portion
> of this and will probably give you some ideas.
I'll try that.
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 | Dave Cramer | 2003-08-14 12:00:12 | query tuning |
| Previous Message | Oleg Bartunov | 2003-08-14 08:20:45 | Re: tsearch2 in 7.4beta1 compile problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-08-14 12:07:18 | Re: pqgetresultset problem |
| Previous Message | P.Harikrishnan | 2003-08-14 09:18:33 | Re: pqgetresultset problem |