Re: debug a mess

Wei Weng <wweng@kencast.com> writes:
> The entire code from PQconnect until PQfinish goes like this:

That sure looks harmless.  I wonder if there is something failing in the
PQconnect() step (like the queries that libpq sends on its own)?

I'd suggest enabling query logging --- see postgresql.conf, or just doexport PGOPTIONS="--log_statement=1"
before starting your program.  (Check Admin Guide first, as this
parameter got renamed recently.)  Then look in the postmaster log to get
a better idea of what's really going on.

BTW, I'm pretty sure that PQclear, and most other libpq functions,
behave sanely when handed a null pointer.  So the test in
>     if (res)
>         PQclear(res);
is unnecessary.
        regards, tom lane