"Bojan Jovanovic" <[EMAIL PROTECTED]> writes: > We just upgraded to 8.2.4, and noticed that psql does not display error > messages, e.g.: > ... > shp_production=# select * from asdfafsdf;
On my system I compiled 8.2.4 as well, and not only would an interactive session like yours display no error messages, but psql even lost its ability to echo messages to the command line: $ psql db_that_does_not_exist psql: $ So I starting adding printf() statements to libpq.so.5 to see what was going on, and, when I added a printf() to fe-protocol3.c, suddenly libpq regained its ability to produce error messages! Removing my printf() then had no further effect; it was simply re-compiling fe-protocol3.c that must have done the trick. I have had no further problems. I note that gcc-4.1 was upgraded on my (Debian unstable) system between my first having compiled PostgreSQL, and the compilation today that resulted in a working libpq: version that broke fe-protocol3 -> 4.1.2-12 version that fixed fe-protocol3 -> 4.1.2-14 Anyone who wishes to dive further into the secrets of "The Libpq Who Would Print No Error Messages" may examine it here: http://rhodesmill.org/tmp/libpq.so.5 By placing it in the current directory and running psql with LD_PRELOAD set, you can see the problem for yourself (assuming that your system has enough libraries in common that this libpq can resolve its symbols): $ LD_PRELOAD=$PWD/libpq.so.5 psql psql: $ If anyone decompiles it and determines why its machine code is broken whereas the machine code produced by my gcc today works, I would be fascinated to know. I wonder whether libpq engages in dangerous and undefined C behavior that only works if the compiler happens to be in the mood, or whether this was a bug in gcc-4.1? I noted, by the way, that the broken and the working libpq on my system at this moment both link against the same libraries; so it must be a difference in libpq itself, not anything beneath it. -- Brandon Craig Rhodes [EMAIL PROTECTED] http://rhodesmill.org/brandon ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
