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