On 01/08/2010 09:31 AM, Konrad Garus wrote:
2010/1/8 Tom Lane<t...@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.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to