| From: | Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com> |
|---|---|
| To: | isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: PG 9.0.1 upgrade issues |
| Date: | 2010-10-15 19:30:48 |
| Message-ID: | 26214464-BA47-435E-9633-D148A787BCA0@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Oct 16, 2010, at 12:48 AM, Isabella Ghiurea wrote:
> ERROR: column t.tgisconstraint does not exist at character 387
> 2010-10-15 12:09:56 PDT[25262]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p.proname, ds.description, pn.nspname AS procnsp FROM pg_trigger t LEFT OUTER JOIN pg_proc p
Seems you are using connectors of PG8.4.4 with PG9.0
tgisconstraint column is no more part of pg_trigger table of PG9.0
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
Mob: +91-9011042623
Web:www.EnterpriseDB.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-10-15 19:31:45 | Re: PG 9.0.1 upgrade issues |
| Previous Message | Isabella Ghiurea | 2010-10-15 19:28:53 | Re: PG 9.0.1 upgrade issues |