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
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql

Reply via email to