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?
JeffJeff 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]