[HACKERS] Multiple queries in transit

2011-10-31 Thread Mark Hills
We have a user interface which fetches and displays many small pieces of distinct information from a PostgreSQL database. * fetches are simple lookups across a diverse set of tables, in response to events on another data source * uses PQsendQuery() on a non-blocking socket But data fetches

Re: [HACKERS] Multiple queries in transit

2011-10-31 Thread Mark Hills
On Mon, 31 Oct 2011, Tom Lane wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: On 31.10.2011 17:44, Mark Hills wrote: Could libpq be reasonably modified to allow this? I believe it's doable in theory, no-one has just gotten around to it. Patches are welcome

[HACKERS] libpq: Return of NULL from PQexec

2011-09-12 Thread Mark Hills
The libpq documentation for PQexec states: If a null pointer is returned, it should be treated like a PGRES_FATAL_ERROR result But this contradicts the example programs; eg. from Example Program 1: /* Start a transaction block */ res = PQexec(conn, BEGIN); if (PQresultStatus(res)