[PyGreSQL] Retrieve Result Status

[Christoph Zwerschke]

Qian Xu schrieb:
> But I want to get the status information. Precisely the information
> about frontend/backend protocal, after a SQL-statement is execute.
> 
> The following is a list of backend IPC commands (v3)

These protocol details seem to be one level below the libpq interface 
that PyGreSQL is using. Where is this list coming from? I haven't seen 
it anywhere in the PostgreSQL documentation.

So far PyGreSQL has only status and error attributes for the connection, 
but not for queries. You only get the coarse information whether the 
query succeeded and the query object, number of rows or OID if it did, 
or an exception is thrown otherwise.

Some more status and error conditions could be made available via libpq 
(PQresultStatus, PQresStatus, PQresultErrorMessage, PQresultErrorField), 
but unfortunately this has not yet been implemented in PyGreSQL. It's 
one of the things I suggest to tackle in version 4.1. Particularly, I 
always wanted to see the SQLSTATE exposed.

-- Christoph