I used if (PQresultStatus(res) != PGRES_TUPLES_OK) and it is fine now. Thanks, JB
On Tue, Aug 11, 2009 at 3:35 PM, Juan Backson <juanback...@gmail.com> wrote: > Hi, > In my source code, I have: > > res = PQexec(conn,"select * from resource"); > if(PQresultStatus(res) != PGRES_COMMAND_OK){ > switch_log_printf(SWITCH_CHANNEL_LOG,SWITCH_LOG_ERROR,"PQexec > failed:%s\n",PQerrorMessage(conn)); > PQclear(res); > return NULL; > } > PQclear(res); > > When it is executed, I am getting PGexec failed error , but the return > value of PQerrorMessage(conn) is empty. > > Does anyone know why? > > Thanks, > JB >