On 01/08/2010 09:31 AM, Konrad Garus wrote:
2010/1/8 Tom Lane<tgl@xxxxxxxxxxxxx>:
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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general