Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B8F6E6325D1 for ; Mon, 17 Aug 2009 09:55:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 41228-05 for ; Mon, 17 Aug 2009 12:54:56 +0000 (UTC) X-Greylist: delayed 00:08:36.115593 by SQLgrey-1.7.6 Received: from smtp-vbr16.xs4all.nl (smtp-vbr16.xs4all.nl [194.109.24.36]) by mail.postgresql.org (Postfix) with ESMTP id 6C1BE62DB89 for ; Mon, 17 Aug 2009 09:55:03 -0300 (ADT) Received: from [0.0.0.0] ([80.101.116.150]) by smtp-vbr16.xs4all.nl (8.13.8/8.13.8) with ESMTP id n7HCkKY7096393 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 17 Aug 2009 14:46:24 +0200 (CEST) (envelope-from yeb.havinga@portavita.nl) Message-ID: <4A8951C5.5030107@portavita.nl> Date: Mon, 17 Aug 2009 14:49:09 +0200 From: Yeb Havinga User-Agent: Thunderbird 2.0.0.22 (Windows/20090605) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Multiple simultaneous queries on single connection Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by XS4ALL Virus Scanner X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/84 X-Sequence-Number: 32993 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