Search Postgresql Archives

Re: Transaction question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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.klaver@xxxxxxxxx



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux