| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Konrad Garus <konrad(dot)garus(at)gmail(dot)com> |
| Cc: | 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:43:54 |
| Message-ID: | 9137.1262972634@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Konrad Garus <konrad(dot)garus(at)gmail(dot)com> writes:
> 2010/1/8 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>> 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.
I'm still baffled then, and am starting to think that this really needs
some investigation with a debugger. How are you with gdb? Or is there
a chance of letting me or another developer poke at (a copy of) your
database?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2010-01-08 17:49:31 | Re: Table appears on listing but can't drop it |
| Previous Message | Konrad Garus | 2010-01-08 17:39:16 | Re: Rows missing from table despite FK constraint |