Re: any way for a transaction to "see" inserts done earlier in the transaction?

On 04/16/2014 07:06 PM, Susan Cassidy wrote:

Yes, it is the same connection.  It is all the same transaction.

Susan


On Wed, Apr 16, 2014 at 5:00 PM, John R Pierce <pierce@hogranch.com <mailto:pierce@hogranch.com>> wrote:

    On 4/16/2014 4:53 PM, Susan Cassidy wrote:

        Well, it isn't working for me right now.  It can't "see" a row that was inserted earlier in the transaction.  It is a new primary key, and when I SELECT it, it isn't found.


    are you using the same connection ?   it won't be visible to a different connection until its committed.

    --
    john r pierce                                      37N 122W
    somewhere on the middle of the left coast

Any chance you accidentally fired of a rollback?

-Andy