Re: SQLSTATE not updated in ecpg program.

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