Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 7B0AE1337BA3
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 15 Oct 2010 16:31:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 23989-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 15 Oct 2010 19:30:57 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com
	[74.125.83.174])
	by mail.postgresql.org (Postfix) with ESMTP id 5D64B1337BA9
	for <pgsql-admin@postgresql.org>; Fri, 15 Oct 2010 16:30:56 -0300 (ADT)
Received: by pva18 with SMTP id 18so34183pva.19
	for <pgsql-admin@postgresql.org>; Fri, 15 Oct 2010 12:30:55 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:subject:mime-version
	:content-type:from:in-reply-to:date:cc:content-transfer-encoding
	:message-id:references:to:x-mailer;
	bh=VtLpVmxrOLPtZzDyY1+S+sVPwwOvC2qlW3WWZApNkco=;
	b=VIY93Axjc8X8/VRJ7yzh+v9Qn343M7rPmxLv2ZV5eAFfFz5/WgQOrva2bhG4vUwo6f
	DWqW1NVsaCRTRxfnMgy6ISCca3zbDybq/RBGUBFRz3N5GbGw6V91yJjIDP99nfGnrI3q
	S9qNK647rd3KKg+87tBlJllW9BmoBEjq1gh9g=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=BxTimEuCje4wL0k8L2WbUy83tYpBiLIF1tLkNi/XtlS+yXAGnXZkH5RdDr83gOJOTE
	JI/OFO1GlxTVjeMvqv4TnYdYObVTVRLNL/bpHLfHFbPAMUeNY33mDrAYufgTLJ4cnNdc
	jREIB41dRKTEQAODQPhPZaXkSs/l6jyD9T5jY=
Received: by 10.142.221.18 with SMTP id t18mr996344wfg.402.1287171055068;
	Fri, 15 Oct 2010 12:30:55 -0700 (PDT)
Received: from [192.168.23.162] ([121.241.184.130])
	by mx.google.com with ESMTPS id w42sm7591602wfh.3.2010.10.15.12.30.52
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Fri, 15 Oct 2010 12:30:53 -0700 (PDT)
Subject: Re: PG 9.0.1 upgrade issues
Mime-Version: 1.0 (Apple Message framework v1081)
Content-Type: text/plain; charset=us-ascii
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: <4CB8A8F4.2050100@nrc-cnrc.gc.ca>
Date: Sat, 16 Oct 2010 01:00:48 +0530
Cc: <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <26214464-BA47-435E-9633-D148A787BCA0@gmail.com>
References: <4CB8A8F4.2050100@nrc-cnrc.gc.ca>
To: isabella.ghiurea@nrc-cnrc.gc.ca
X-Mailer: Apple Mail (2.1081)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201010/133
X-Sequence-Number: 35874


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=20

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