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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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