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.