| 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: | Whole Thread | Raw Message | 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?
| 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 |