Multiple simultaneous queries on single connection

From: Yeb Havinga <yeb(dot)havinga(at)portavita(dot)nl>
To: pgsql-sql(at)postgresql(dot)org
Subject: Multiple simultaneous queries on single connection
Date: 2009-08-17 12:49:09
Message-ID: 4A8951C5.5030107@portavita.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Verheyden 2009-08-18 07:04:42 FW: simple? query
Previous Message Joshua Tolley 2009-08-14 22:28:20 Re: Field or record level encryption / decryption