From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Jeff Ross <jross(at)wykids(dot)org> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Transaction question |
Date: | 2012-07-11 02:39:05 |
Message-ID: | 4FFCE749.8050909@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/10/2012 07:30 PM, Jeff Ross wrote:
> On 7/10/12 6:21 PM, Adrian Klaver wrote:
>> On 07/10/2012 01:06 PM, Jeff Ross wrote:
>>> Hi all,
>>>
>>>
>>> Thanks for any and all ideas!
>>
>> For your initial attempt everything was done in one session?
>
> All the inserts were done in one session, yes.
>>
>> I am also confused by this:
>> 2012-06-19 15:37:36.258912500 <www%wykids> LOG: statement: commit
>> 2012-06-19 15:29:11.573396500 <www%wykids> LOG: statement: update
>> survey_response set srv_resp_submitted = now() where srv_resp_srv_id =
>> 2 and srv_resp_pp_id = 25399
>>
>> Note the time stamps. Is this the actual log?
>
> Crap. I noticed that I'd somehow got another update statement when I
> pasted into the e-mail so I altered the srv_resp_pp_id to match rather
> than go get the real entry from the logs again. That is for sure my bad
> and I apologize! The sequence of events are as I described, though. The
> inserts happen inside a transaction, the update happens immediately
> after the commit.
So would it be possible to see the actual log sequence?
>
> Jeff
>>
>>>
>>> Jeff Ross
>>> Wyoming Children's Action Alliance
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Kupershmidt | 2012-07-11 03:20:47 | Re: Python + listen/notify |
Previous Message | Jeff Ross | 2012-07-11 02:30:04 | Re: Transaction question |