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