Re: Transaction question

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(at)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?

>
> Jeff

>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com