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