From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Konrad Garus <konrad(dot)garus(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Rows missing from table despite FK constraint |
Date: | 2010-01-08 17:35:07 |
Message-ID: | 4B476CCB.4090605@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 01/08/2010 09:31 AM, Konrad Garus wrote:
> 2010/1/8 Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Konrad Garus | 2010-01-08 17:39:16 | Re: Rows missing from table despite FK constraint |
Previous Message | Konrad Garus | 2010-01-08 17:31:37 | Re: Rows missing from table despite FK constraint |