Обсуждение: When does PQstatus() update?
Hi, Just wondering when the result of the function PQstatus() gets updated? Can I expect it to be updated while connected even without performing any transactions/communications with the backend? I tried PQexec()'ing a "BEGIN TRANSACTION" on a dead backend and immediately checked PQstatus() as well as PQresultStatus(). PQstatus() returned a CONNECTION_OK while PQresultStatus() returned PGRES_FATAL_ERROR. I tried it again on the same dead-connection backend a couple of seconds later and got a CONNECTION_BAD fro PQstatus() and a PGRES_NONFATAL_ERROR from PQresultStatus(). L L Richi Plana 8^) ,-,-. ,-,-. ,-,-. ,-,-. ,- LL LL Systems Administrator / / \ \ / / \ \ / / \ \ / / \ \ / / LLLLL Mosaic Communications, Inc. \ \ / / \ \ / / \ \ / / \ \ / / LLLLL mailto:richip@mozcom.com `-'-' `-'-' `-'-' `-'-' ------------------------------------------------------------------------ P G P Key available at http://www2.mozcom.com/~richip/richip.asc Tired of Spam? Join this CAUCE! http://www.cauce.org/
Hi, I have some trouble with subselects. (Version 6.3). If I try Select name, address from costumers where cod_costumer in ( Select cod_costumer from logins where total_usage > 0); It take lots of time (really I din't wait till the end). But if I manualy split in Select cod_costumer from logins where total_usage > 0; getting ( 1, 9, 15, 18 , 40) and then use Select name, address from costumers where cod_costumer in ( 1, 9, 15, 18 , 40); All is OK. Is this type of subselect suported ? Thanks Giovanni Floridia