Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 7D579C14E5E for ; Fri, 23 Mar 2012 19:11:45 -0300 (ADT) Received: from [76.14.161.106] (helo=newserver.jfcomputer.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SBCi0-0003q7-Ss for pgsql-sql@postgresql.org; Fri, 23 Mar 2012 22:11:45 +0000 Received: from localhost (unknown [127.0.0.1]) by newserver.jfcomputer.com (Postfix) with ESMTP id 363EA1221A for ; Fri, 23 Mar 2012 22:11:32 +0000 (UTC) X-Virus-Scanned: amavisd-new at site Received: from newserver.jfcomputer.com ([127.0.0.1]) by localhost (linux-jfp8.site [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29SQ7mX5Nmsf for ; Fri, 23 Mar 2012 15:11:31 -0700 (PDT) Received: from linux-12.localnet (unknown [192.168.1.254]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: johnf@jfcomputer.com) by newserver.jfcomputer.com (Postfix) with ESMTPSA id 87A0C5F49 for ; Fri, 23 Mar 2012 15:11:31 -0700 (PDT) From: John Fabiani To: pgsql-sql@postgresql.org Subject: Re: Can I read the data without commit Date: Fri, 23 Mar 2012 15:11:31 -0700 Message-ID: <2486453.eI5m84B4e6@linux-12> User-Agent: KMail/4.7.2 (Linux/3.1.9-1.4-desktop; KDE/4.7.2; x86_64; ; ) In-Reply-To: <4F6CF298.5070600@gmail.com> References: <2388789.tLQtTxa0cR@linux-12> <2083844.g5gOAHDHN5@linux-12> <4F6CF298.5070600@gmail.com> MIME-Version: 1.0 Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="us-ascii" X-Host-Lookup-Failed: Reverse DNS lookup failed for 76.14.161.106 (failed) X-Pg-Spam-Score: 1.6 (+) X-Archive-Number: 201203/69 X-Sequence-Number: 36464 On Friday, March 23, 2012 04:00:56 PM Rob Sargent wrote: > And I believe Jonathon confirmed that you could, with the caveat that > you must select from within the transaction. I don't see that you've > laid that out your connection stategy so ymmv. I didn't see Jonathon response? Must be a direct email to me and not to the list. But thanks that helps. Johnf