Multiple simultaneous queries on single connection - Mailing list pgsql-sql

From Yeb Havinga
Subject Multiple simultaneous queries on single connection
Date
Msg-id 4A8951C5.5030107@portavita.nl
Whole thread Raw
Responses Re: Multiple simultaneous queries on single connection  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
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 
multiple connections.

The problem is that multiple connections (from the same application 
instance) do not share the same MVCC snapshot.

Is there a way to have two or more connections see each others 
uncommitted things?

Any thoughts?
Yeb Havinga



pgsql-sql by date:

Previous
From: Joshua Tolley
Date:
Subject: Re: Field or record level encryption / decryption
Next
From: "W. Kinastowski"
Date:
Subject: operator contains in older Pgsql