Postgres Pro
Downloads
Home   >   mailing lists

drop/add fk in transaction - Mailing list pgsql-novice

From Nabil Sayegh
Subject drop/add fk in transaction
Date
Msg-id 1060819776.4750.29.camel@billy
Whole thread Raw
Responses Re: drop/add fk in transaction
List pgsql-novice
Tree view 
Hi all,

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 ?

I'm using 7.3.3

TIA
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de

pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How can I index a substring attribute?
Next
From: Stephan Szabo
Date:
Subject: Re: drop/add fk in transaction