Re: [SQL] Multiple simultaneous queries on single connection

2009-08-19 Thread Yeb Havinga
Hello Craig, list Is there a way to have two or more connections see each others uncommitted things? Not at present. You should be able to use explicitly declared cursors and FETCH to interleave requests for results from one or more queries in the same transation using the one connection, bu

Re: [SQL] Multiple simultaneous queries on single connection

2009-08-18 Thread Craig Ringer
On 17/08/2009 8:49 PM, Yeb Havinga wrote: Hello list, We want to access a postgres database with multiple queries / result sets that are read simultaneously (hence async). The documentation says explicitly that no new PQsendQuery can be send on the same channel before the pqgetresults has return

[SQL] Multiple simultaneous queries on single connection

2009-08-17 Thread Yeb Havinga
Hello list, We want to access a postgres database with multiple queries / result sets that are read simultaneously (hence async). The documentation says explicitly that no new PQsendQuery can be send on the same channel before the pqgetresults has returned null. This means we need to use mult