On Tue, Jul 10, 2012 at 10:06 PM, Jeff Ross <jr...@wykids.org> 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