Re: ERROR: Index pg_toast_8443892_index is not a btree

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: strk <strk(at)keybit(dot)net>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: Index pg_toast_8443892_index is not a btree
Date: 2003-12-10 15:30:22
Message-ID: 3FD73C0E.10802@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> strk <strk(at)keybit(dot)net> writes:
>> The question now is: what does that message mean ?
>
> It means that the "magic number" that should be on the first page of the
> btree index isn't right. We can deduce that something has clobbered the
> first page of the index, but guessing what and how requires much more
> information.

Clobbered or truncated. A zero size index file causes the same message.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2003-12-10 15:52:00 Re: PostgreSQL port to pure Java?
Previous Message Thomas Hallgren 2003-12-10 15:18:59 pljava revisited