pg_upgrade - Mailing list pgsql-admin

From Thyagarajan Vasudevan
Subject pg_upgrade
Date
Msg-id 3A80DD84.B76AFB44@bytekinc.com
Whole thread Raw
List pgsql-admin
Hi All
    I am trying to upgrade from Postgres 6.5 to Postgres 7.0.3. Now, in
the previous version of the Database, i have a lot of triggers which
simulate the Foreign key functionality, by using the checkPrimaryKey and
the checkForeignKey functions defined in refint.c.
    My question is:
        If I use pg_upgrade to shift from 6.5 to 7.0.3, will these
triggers automatically be removed and be converted into a FOREIGN KEY
constraint in the appropriate tables.

Thanks
Thyaga


pgsql-admin by date:

Previous
From: Ragnar Kjørstad
Date:
Subject: Re: ERROR:cannot read block 9053 of mots
Next
From: "Rainer Mager"
Date:
Subject: Problem with JDBC transactions