| 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: | Whole Thread | Raw Message | 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 |