From: | Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com> |
---|---|
To: | Andy Colson <andy(at)squeakycode(dot)net> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: any way for a transaction to "see" inserts done earlier in the transaction? |
Date: | 2014-04-17 15:02:25 |
Message-ID: | CAE3Q8onRgoAgcGmjDQcNBq6Ku_OJrRTkXBzCRb=7LSUjjED_dQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <andy(at)squeakycode(dot)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 <pierce(at)hogranch(dot)com<mailto:
>> pierce(at)hogranch(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Susan Cassidy | 2014-04-17 15:04:28 | Re: any way for a transaction to "see" inserts done earlier in the transaction? |
Previous Message | Susan Cassidy | 2014-04-17 15:01:31 | Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? |