Re: PGExec returns error without any comment

On Thu, Sep 28, 2006 at 05:16:10AM -0700, erkan kolemen wrote:
>         res = PQexec(conn, "select * from lists;");
>         if (PQresultStatus(res) != PGRES_COMMAND_OK)

You're checking for the wrong result status.  Here are some excerpts
from the libpq documentation:

PGRES_COMMAND_OK   Successful completion of a command returning no data.

PGRES_TUPLES_OK   Successful completion of a command returning data (such as a SELECT    or SHOW).
 Note that a SELECT command that happens to retrieve zero rows still shows PGRES_TUPLES_OK.  PGRES_COMMAND_OK is for
commandsthat can never return rows (INSERT, UPDATE, etc.).
 

-- 
Michael Fuhr