Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 648469FA489
	for <pgsql-interfaces-postgresql.org@postgresql.org>;
	Fri, 29 Dec 2006 08:33:48 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 21173-05 for
	<pgsql-interfaces-postgresql.org@postgresql.org>;
	Fri, 29 Dec 2006 08:33:44 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from imf18aec.mail.bellsouth.net (imf18aec.mail.bellsouth.net
	[205.152.59.66])
	by postgresql.org (Postfix) with ESMTP id 68D899FA43C
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Dec 2006 08:33:43 -0400 (AST)
Received: from ibm59aec.bellsouth.net ([65.3.202.13])
	by imf18aec.mail.bellsouth.net with ESMTP id
	<20061229123341.NVIV9582.imf18aec.mail.bellsouth.net@ibm59aec.bellsouth.net>
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Dec 2006 07:33:41 -0500
Received: from wolverine.481sumter.33325.net ([65.3.202.13])
	by ibm59aec.bellsouth.net with ESMTP id
	<20061229123341.YCJJ25343.ibm59aec.bellsouth.net@wolverine.481sumter.33325.net>
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Dec 2006 07:33:41 -0500
From: Ken Jennings <ken_jennings@bellsouth.net>
To: pgsql-interfaces@postgresql.org
Subject: Re: SQLSTATE not updated in ecpg program.
Date: Fri, 29 Dec 2006 07:33:39 -0500
User-Agent: KMail/1.8.2
References: 
 <20061228154207.PSKD18764.ibm58aec.bellsouth.net@mail.bellsouth.net>
	<200612282151.38082.ken_jennings@bellsouth.net>
	<20061229100237.GB28889@feivel.credativ.de>
In-Reply-To: <20061229100237.GB28889@feivel.credativ.de>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200612290733.39612.ken_jennings@bellsouth.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.986 tagged_above=0 required=5 tests=AWL, BAYES_50,
	DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200612/44
X-Sequence-Number: 6378

On Friday 29 December 2006 05:02, Michael Meskes wrote:
> On Thu, Dec 28, 2006 at 09:51:37PM -0500, Ken Jennings wrote:
> > It turns out this is merely a case of stupid administrator tricks.  ldd
> > reported none of the libraries loaded for the testpgc program came
> > from /usr/local/pgsql/lib.  Poking around we discovered a previous
> > administrator had tried installing the SuSE package for postgreSQL a long
> > while ago.  So, the libraries for the old install were being loaded
> > instead of version 8.2.0.  It only works on the Pentium box, because we
> > just built that ourselves without any unnecessary packages.  Duh.
>
> So I take it all works well for you now, right?

Perfectly.  sqlca.sqlstate is happy once again.

Thanks.
Ken Jennings