Re: Can I read the data without commit

If possible have the review done before starting the transaction.  No 
sense in holding on to that stuff too long. Potential concurrency issues 
etc.

On 03/23/2012 03:40 PM, Jonathan S. Katz wrote:
> 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
>