Re: SQLSTATE not updated in ecpg program.

[Ken Jennings <ken_jennings(at)bellsouth(dot)net>]

[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.