Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 067F1C14E5E
	for <pgsql-sql@postgresql.org>; Fri, 23 Mar 2012 18:41:08 -0300 (ADT)
Received: from mail-qc0-f174.google.com ([209.85.216.174])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jonathan.katz@excoventures.com>) id 1SBCEM-0003LK-Lr
	for pgsql-sql@postgresql.org; Fri, 23 Mar 2012 21:41:08 +0000
Received: by qcqw6 with SMTP id w6so2300727qcq.19
	for <pgsql-sql@postgresql.org>; Fri, 23 Mar 2012 14:40:54 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer
	:x-gm-message-state;
	bh=UXB90FxrozVKTpfMPQfqzZvsjqYzQDp3QJWG09y+eOk=;
	b=my4u9DqVNXxiWwHv5uGIhp1TZIY0CSArmnMmwHDUebZlkAtBlt+4XW/NeWK1jEtzPn
	H0Bk1W0pscX29p7wED+ozcEKT3lLhPdGIppbrcGp1IpYYVe+fawtItaq9BmzbiDgOLwE
	dsi5qGMoUlaG82n0tLi0Yg4+F6GCIBLdh/os/OPNr1bZWlYhfG0e0Bmtj2Q1njXCM610
	7kwe92xwfrX8Ah0c1OFqvQIHlTWNpVRo0Bu3sxWkCNxq4tMd116YAEJ4mxK0A/GPUyo+
	4B1RMDGVa7mo3FgnQAkjLF+hlcO+4mhibN7yGJvXavj6U/rirhspFZFhcDBVP/zgHSx1
	O2dg==
Received: by 10.224.71.19 with SMTP id f19mr8010439qaj.0.1332538854003;
	Fri, 23 Mar 2012 14:40:54 -0700 (PDT)
Received: from [192.168.1.102] (rrcs-184-75-23-182.nyc.biz.rr.com.
	[184.75.23.182])
	by mx.google.com with ESMTPS id v8sm15972540qaa.11.2012.03.23.14.40.51
	(version=TLSv1/SSLv3 cipher=OTHER);
	Fri, 23 Mar 2012 14:40:51 -0700 (PDT)
Subject: Re: Can I read the data without commit
Mime-Version: 1.0 (Apple Message framework v1257)
Content-Type: text/plain; charset=us-ascii
From: "Jonathan S. Katz" <jonathan.katz@excoventures.com>
In-Reply-To: <2388789.tLQtTxa0cR@linux-12>
Date: Fri, 23 Mar 2012 17:40:49 -0400
Cc: pgsql-sql@postgresql.org
Content-Transfer-Encoding: 7bit
Message-Id: <F4CA35B7-B59B-4226-BEC4-AA13636F446E@excoventures.com>
References: <2388789.tLQtTxa0cR@linux-12>
To: John Fabiani <johnf@jfcomputer.com>
X-Mailer: Apple Mail (2.1257)
X-Gm-Message-State: 
 ALoCoQlkCoDwmAACWFptFdHJzilAP0UKu3EC3EZ5zdHANzaiZ1aMyvSlETZ4MhEoX9DTtXpfoVnu
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201203/65
X-Sequence-Number: 36460

On Mar 23, 2012, at 5:33 PM, John Fabiani wrote:

> I start a transaction.
> Begin
> 
> Then I insert a lot of data - let's say two hundred rows.
> 
> Now I need to read the same data (so the user can review).
> 
> If the user thinks all is right then 
> commit.
> 
> Can I read the data I just inserted without committing?

Yes, as long as you run your SELECT within the transaction that you started.

Jonathan