drop/add fk in transaction

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: drop/add fk in transaction
Date: 2003-08-14 00:09:36
Message-ID: 1060819776.4750.29.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-08-14 00:36:05 Re: drop/add fk in transaction
Previous Message Martijn van Oosterhout 2003-08-13 23:43:48 Re: Sorting Problem

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2003-08-14 00:36:05 Re: drop/add fk in transaction
Previous Message Stephan Szabo 2003-08-13 23:22:57 Re: How can I index a substring attribute?