Re: meaning of PQresultStatus types - Mailing list pgsql-general

From jois.de.vivre@gmail.com
Subject Re: meaning of PQresultStatus types
Date
Msg-id 1148409378.094424.236200@j55g2000cwa.googlegroups.com
Whole thread Raw
In response to meaning of PQresultStatus types  (jois.de.vivre@gmail.com)
List pgsql-general
jois.de.vi...@gmail.com wrote:
> I'm currently trying to understand how to deal with the return values
> of PGresultStatus in terms of error handling in my application.  The
> postgres manual describes the return codes of PGresultStatus as:
>
> PGRES_EMPTY_QUERY:  The string sent to the server was empty.
> PGRES_COMMAND_OK:   Successful completion of a command returning no
> data.
> PGRES_TUPLES_OK: Successful completion of a command returning data.
> PGRES_COPY_OUT: Copy Out (from server) data transfer started.
> PGRES_COPY_IN: Copy In (to server) data transfer started.
> PGRES_BAD_RESPONSE: The server's response was not understood.
> PGRES_NONFATAL_ERROR: A nonfatal error (a notice or warning) occurred.
> PGRES_FATAL_ERROR: A fatal error occurred.
>
> My question is, what constitutes a PGRES_FATAL_ERROR or a
> PGRES_BAD_RESPONSE?
>
> I took PGRES_BAD_RESPONSE to mean that the libpq library was older than
> the database being connected to and so the response was not being
> handled properly.
>
> I took PGRES_FATAL_ERROR to mean that critical system errors had
> occurred (like running out of memory).  While googling for more
> information regarding this, I found people had said that this can be
> generated for any queries that were executed after a failed query.
> These posting were however very old and I didn't know if any of this
> had been changed.
>
> Could someone tell me where I can get more information regarding these
> two particular error codes or confirm/deny my assumptions?
>
> Thanks

I forgot to mention that I am using Postgres 8.0.3


pgsql-general by date:

Previous
From: jois.de.vivre@gmail.com
Date:
Subject: meaning of PQresultStatus types
Next
From: "nuno"
Date:
Subject: column order