Re: ERROR: Index pg_toast_8443892_index is not a btree - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ERROR: Index pg_toast_8443892_index is not a btree
Date
Msg-id 6683.1071072475@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: Index pg_toast_8443892_index is not a btree  (strk <strk@keybit.net>)
Responses Re: ERROR: Index pg_toast_8443892_index is not a btree  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
strk <strk@keybit.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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: PostgreSQL port to pure Java?
Next
From: Andreas Pflug
Date:
Subject: Re: [pgadmin-support] Cannot add an column of type serial