On Feb 13, 2003, Tom Lane wrote:
>
> Laurette Cisneros <laurette@nextbus.com> writes:
> > This is the error in the pgsql log:
> > 2003-02-13 16:21:42 [8843] ERROR: Index external_signstops_pkey is
> > not a btree
>
> This says that one of two fields that should never change, in fixed
> positions in the first block of a btree index, didn't have the right
> values. I am not aware of any PG bugs that could overwrite those
> fields. I think the most likely bet is that you've got hardware
> issues ... have you run memory and disk diagnostics lately?
I am seeing this same problem on two separate machines, one brand new, one
older. Not sure yet what is causing it, but seems pretty unlikely that it
is hardware-related.
Ed
