Re: failed to re-find parent key in "..." for deletion target page

From: Brian Hirt <bhirt(at)mobygames(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: failed to re-find parent key in "..." for deletion target page
Date: 2007-08-13 13:43:26
Message-ID: 9694D7CC-D906-4803-82AF-E407945E3DFD@mobygames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Unfortunately, I wasn't able to get Tom the requested files.

On Aug 10, 2007, at 8:11 AM, Heikki Linnakangas wrote:

> Any news on this?
>
> Tom Lane wrote:
>> Brian Hirt <bhirt(at)mobygames(dot)com> writes:
>>> basement_dev=# VACUUM FULL developer_name;
>>> ERROR: failed to re-find parent key in
>>> "developer_name_developer_name" for deletion target page 163
>>
>> Oh dear, I thought we'd fixed that.
>>
>> Can you send me copies of this index file ... and preferably the
>> underlying table too?
>>
>> You should be able to get out of it by REINDEXing, but we need to
>> find
>> the cause first.
>>
>> regards, tom lane
>
> --
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-08-13 14:44:22 Re: ON DELETE SET NULL clauses do error when more than two columns are referenced to one table
Previous Message Gregory Stark 2007-08-13 13:10:40 Re: ON DELETE SET NULL clauses do error when more than two columns are referenced to one table