Re: Rows missing from table despite FK constraint

On 01/08/2010 09:31 AM, Konrad Garus wrote:
> 2010/1/8 Tom Lane<tgl@sss.pgh.pa.us>:
>> Oh, so the row *is* there.
>
> Right. I'm happy to see it.
>
>>   What the above says is that you have a
>> corrupt index on attachment_id, which you should be able to fix via
>> REINDEX.
>
> This is not correct. The dumps are made with pg_dump. We did reindex
> on the table. I also tried looking for the row with another index and
> with seq scan and could not see it.
>

This looks a lot like this thread:
http://archives.postgresql.org/pgsql-general/2009-12/msg00726.php

Could we see the schema and indexes for this table?

--
Adrian Klaver
adrian.klaver@gmail.com