| From: | Thyagarajan Vasudevan <thyaga(at)vitalect(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | pg_upgrade |
| Date: | 2001-02-07 05:30:44 |
| Message-ID: | 3A80DD84.B76AFB44@bytekinc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter T Mount | 2001-02-07 08:40:29 | Re: Re: [ADMIN] |
| Previous Message | Ragnar Kjørstad | 2001-02-07 03:31:35 | Re: ERROR:cannot read block 9053 of mots |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed Loehr | 2001-02-07 06:57:20 | Off-topic: usenet sources? |
| Previous Message | Tod McQuillin | 2001-02-07 04:51:00 | Re: Re: Solaris 8 Problems redux |