Re: Transaction question

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(dot)klaver(at)gmail(dot)com