Re: Transaction question

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Jeff Ross <jross(at)wykids(dot)org>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Transaction question
Date: 2012-07-11 20:07:52
Message-ID: 4FFDDD18.4000309@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-07-11 20:15:03 Re: Transaction question
Previous Message Adrian Klaver 2012-07-11 20:01:55 Re: Error with plpython