On Monday March 31 2003 3:38, Ed L. wrote: > On Feb 13, 2003, Tom Lane wrote: > > Laurette Cisneros <[EMAIL PROTECTED]> 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.
I am dabbling for the first time with a (crashing) C trigger, so that may be the culprit here. Ed ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]