From: | Paul M Foster <paulf(at)quillandmouse(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Returns from ExecTuplesOk() SOLVED |
Date: | 2002-04-22 22:31:43 |
Message-ID: | 20020422183143.A10844@quillandmouse.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Harding | 2002-04-22 22:36:21 | Re: nested transactions |
Previous Message | Tom Lane | 2002-04-22 22:11:30 | Re: nested transactions |