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