Multiple simultaneous queries on single connection

Поиск
Список
Период
Сортировка
От Yeb Havinga
Тема Multiple simultaneous queries on single connection
Дата
Msg-id 4A8951C5.5030107@portavita.nl
обсуждение исходный текст
Ответы Re: Multiple simultaneous queries on single connection
Список 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 по дате отправления:

Предыдущее
От: Joshua Tolley
Дата:
Сообщение: Re: Field or record level encryption / decryption
Следующее
От: "W. Kinastowski"
Дата:
Сообщение: operator contains in older Pgsql