Search Postgresql Archives

Re: Transaction question

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

 





On Tue, Jul 10, 2012 at 10:06 PM, Jeff Ross <jross@xxxxxxxxxx> wrote:
 
2012-06-19 15:37:36.283752500 <www%wykids> LOG:  statement: update survey_response set srv_resp_submitted = now() where srv_resp_srv_id = 2 and srv_resp_pp_id = 25399

jross@wykids localhost# select * from survey_response where srv_resp_submitted is not null and srv_resp_srv_id = 2 and srv_resp_pp_id not in (select srv_answers_pp_id from survey_answers where srv_answers_srv_id = 2);
 srv_resp_id | srv_resp_srv_id | srv_resp_pp_id | srv_resp_invite       |    srv_resp_first_look     | srv_resp_submitted
-------------+-----------------+----------------+----------------------------+----------------------------+----------------------------
        5674 |               2 |          25399 | 2012-06-19 15:12:49.589233 | 2012-06-19 15:33:05.547012 | 2012-06-19 15:38:16.724393


The timestamps don't match - something updated the record after 15:37:36  . 
Also, are the fields like srv_answers_srv_id character fields? The inserts are quoting them like varchars, which seems odd.

Greetings
Marcin

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux