On 07/11/2012 07:01 AM, Jeff Ross wrote:
On 7/10/12 8:39 PM, Adrian Klaver wrote:
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.
So would it be possible to see the actual log sequence?
Absolutely.
2012-06-19 15:37:36.257256500 <www%wykids> LOG: statement: INSERT INTO
survey_answers
(srv_answers_srv_id,srv_answers_pp_id,srv_answers_question_id,srv_answers_answer,srv_answers_answer_text,srv_answers_rank,srv_answers_sub_question_id)
VALUES ('2','25399','20','1',NULL,NULL,NULL)
2012-06-19 15:37:36.258912500 <www%wykids> LOG: statement: commit
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
Hmm, nothing stands out. Some bottom of the bag ideas:
1) Is there more than one survey_answers table in the database, in
different schema?
2) When you are looking for the survey answers in the table are you
connecting to the parent or child database in the replication setup?
Thanks!
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
