Re: Returns from ExecTuplesOk() SOLVED - Mailing list pgsql-general

From Paul M Foster
Subject Re: Returns from ExecTuplesOk() SOLVED
Date
Msg-id 20020422183143.A10844@quillandmouse.com
Whole thread Raw
In response to Returns from ExecTuplesOk()  (Paul M Foster <paulf@quillandmouse.com>)
List pgsql-general
On Sun, Apr 21, 2002 at 10:58:10PM -0400, Paul M Foster wrote:

> I'm confused. In libpq++, it seems that ExecTuplesOk() should return
> PGRES_TUPLES_OK if a tuples are returned from the query. Yet I'm getting
> PGRES_COMMAND_OK instead. When I then check Tuples(), it returns 1. Am I
> missing something?
>
> Paul

Okay, I answered this myself.

Apparently, ExecCommandOk() and ExecTuplesOk() return true or false, not
PGRES_* values. Beyond that, there is no other clue about why a query
would fail. The PGRES_* values are only returned by the Exec() function,
which you are discouraged from using, for some reason.

I read this in the docs in the first place, but dismissed it as a
misprint. Duh.

Paul

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: nested transactions
Next
From: "Ian Harding"
Date:
Subject: Re: nested transactions