Skip site navigation (1) Skip section navigation (2)

Re: SQLSTATE not updated in ecpg program.

From: Ken Jennings <ken_jennings(at)bellsouth(dot)net>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: SQLSTATE not updated in ecpg program.
Date: 2006-12-29 02:51:37
Message-ID: 200612282151.38082.ken_jennings@bellsouth.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
[snip]
> sqlca is being partially overwritten during EXEC SQL calls.  [...]

> This problem happens with 8.2.0 installed on our Athlon systems:
> Linux wolverine 2.6.13-15.12-default #1 Thu Aug 24 11:23:58 UTC 2006 i686
> athlon i386 GNU/Linux
> Linux cerebro 2.6.13-15.12-smp #1 SMP Thu Aug 24 11:23:58 UTC 2006 i686
> athlon i386 GNU/Linux

> We found this problem does not occur when the program is built and run on a
> system using an actual Pentium 4:
> Linux nawm 2.6.13-15.12-default #1 Thu Aug 24 11:23:58 UTC 2006 i686 i686
> i386 GNU/Linux

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.

In response to

Responses

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2006-12-29 10:01:53
Subject: Re: SQLSTATE not updated in ecpg program.
Previous:From: L BayukDate: 2006-12-29 02:13:53
Subject: Re: BCC55 and libpq 8.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group