On Mar 23, 2012, at 5:33 PM, John Fabiani wrote:
> I start a transaction.
> 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
> Can I read the data I just inserted without committing?
Yes, as long as you run your SELECT within the transaction that you started.
In response to
pgsql-sql by date
|Next:||From: Rob Sargent||Date: 2012-03-23 21:46:10|
|Subject: Re: Can I read the data without commit|
|Previous:||From: John Fabiani||Date: 2012-03-23 21:33:00|
|Subject: Can I read the data without commit|