Re: PG 9.0.1 upgrade issues - Mailing list 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
tLEFT 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