Re: Transaction question

On 7/11/12 5:13 PM, Adrian Klaver wrote:
> On 07/11/2012 04:02 PM, Jeff Ross wrote:
>> On 7/11/12 3:52 PM, Adrian Klaver wrote:
>
>>>
>>> Is there an index on this table?
>>> If so have you tried a REINDEX?
>>>
>>
>> Here's the table definition:
>>
>> jross@nirvana:/home/jross $ psql wykids
>> psql (9.1.4, server 9.1.3)
>> Type "help" for help.
>>
>> wykids=# \d survey_answers
>>                                            Table "public.survey_answers"
>>             Column            |  Type | Modifiers
>> -----------------------------+---------+-------------------------------------------------------------------------
>>
>>
>>   srv_answers_id              | integer | not null default
>> nextval('survey_answers_srv_answers_id_seq'::regclass)
>>   srv_answers_srv_id          | integer | not null
>>   srv_answers_pp_id           | integer | not null
>>   srv_answers_question_id     | integer | not null
>>   srv_answers_answer          | integer |
>>   srv_answers_answer_text     | text    |
>>   srv_answers_rank            | integer |
>>   srv_answers_sub_question_id | integer |
>> Indexes:
>>      "survey_answers_pkey" PRIMARY KEY, btree (srv_answers_id)
>> Foreign-key constraints:
>>      "survey_answers_srv_answers_answer_fkey" FOREIGN KEY
>> (srv_answers_answer) REFERENCES
>> survey_possible_answers(srv_pos_answers_id)
>>      "survey_answers_srv_answers_pp_id_fkey" FOREIGN KEY
>> (srv_answers_pp_id) REFERENCES people(pp_id)
>>      "survey_answers_srv_answers_question_id_fkey" FOREIGN KEY
>> (srv_answers_question_id) REFERENCES survey_questions(srv_question_id)
>>      "survey_answers_srv_answers_srv_id_fkey" FOREIGN KEY
>> (srv_answers_srv_id) REFERENCES surveys(srv_id)
>>
>> wykids=#
>>
>> I haven't re-indexed that table but somehow I find it hard to believe
>> that a reindex can make those rows appear. I just tried it on my
>> development server--no change.
>
> The development server has the same issue with missing records?

Yes, but it is db dropped and reloaded daily from the real server so
that is to be expected.
>
>>
>> Jeff
>
>>
>
>