From: Vibhor Kumar <vibhor.aim@gmail.com>
To: isabella.ghiurea@nrc-cnrc.gc.ca
Cc: pgsql-admin@postgresql.org
Subject: Re: PG 9.0.1 upgrade issues
Date: Sat, 16 Oct 2010 01:00:48 +0530
Message-ID: <26214464-BA47-435E-9633-D148A787BCA0@gmail.com> (raw)
In-Reply-To: <4CB8A8F4.2050100@nrc-cnrc.gc.ca>
References: <4CB8A8F4.2050100@nrc-cnrc.gc.ca>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vibhor.aim@gmail.com, isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: PG 9.0.1 upgrade issues
In-Reply-To: <26214464-BA47-435E-9633-D148A787BCA0@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox