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?
regards, tom lane