Re: Returns from ExecTuplesOk() SOLVED

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

In response to

Browse pgsql-general by date

  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