No. One gets done automatically when the transaction fails, however. I can see it in the log.
Susan On Wed, Apr 16, 2014 at 6:26 PM, Andy Colson <a...@squeakycode.net> wrote: > 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 <pie...@hogranch.com<mailto: >> pie...@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 > >
