Re: [HACKERS] index corruption?

2003-03-31 Thread Ed L.
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

Re: [HACKERS] index corruption?

2003-03-31 Thread Ed L.
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

Re: [HACKERS] index corruption?

2003-03-31 Thread Tom Lane
Ed L. [EMAIL PROTECTED] writes: 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

Re: [HACKERS] index corruption?

2003-03-31 Thread Ed L.
On Monday March 31 2003 3:54, Tom Lane wrote: Ed L. [EMAIL PROTECTED] writes: 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

Re: [HACKERS] index corruption?

2003-03-31 Thread scott.marlowe
On Mon, 31 Mar 2003, 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

Re: [HACKERS] index corruption?

2003-02-13 Thread Tom Lane
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

<    1   2