Skip site navigation (1) Skip section navigation (2)

Re: What does error code PGSQL_TUPLES_OK (2) actually mean?

From: ljb <ljb220(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What does error code PGSQL_TUPLES_OK (2) actually mean?
Date: 2004-05-31 00:31:18
Message-ID: c9ducm$2ed5$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
john_ramsden(at)sagitta-ps(dot)com wrote:
> I have ported a PHP MySQL app to PostgreSQL, and a pg_send_query()
> call is returning error code 2 (PGSQL_TUPLES_OK). Unfortunately
> the PHP manual lists the error codes but doesn't indicate what
> they mean, and pg_result_error() returns a blank message.
>
> As the token ends in '_OK', I suspect 'error' 2 isn't an error
> at all, but some kind of OK status. However, I'd like to confirm
> that. Does anyone have a reference where PostgreSQL error codes
> are listed along with the meaning of each?

(You might be better off with this in comp.databases.postgresql.interfaces.php)

I don't understand - pg_send_query() returns true/false, not an error code,
and there's no result handle to use with pg_result_error until you call
pg_get_result. Are you really trying to do asynchronous queries?

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-05-31 04:30:58
Subject: Re: Backend crash
Previous:From: Martijn van OosterhoutDate: 2004-05-30 23:34:25
Subject: Receiving three month old messages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group