
This is the second time I've seen this.

7.3.2

This particular table is empty.  I'm trying to read it in a perl script.
It doesn't duplicate regularly (I have a script that creates the database
by copying table data from another databases).

This is the error in the pgsql log:
2003-02-13 16:21:42 [8843]   ERROR:  Index external_signstops_pkey is not a
btree
2003-02-13 16:21:42 [8843]   ERROR:  current transaction is aborted,
queries ignored until end of transaction block

Any ideas?

-- 
Laurette Cisneros, L.D.
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
"No man is wise enough by himself"
-- Titus Maccius Plautus 
   (254 Bc - 184 BC), Miles Gloriosus


Thu, 13 Feb 2003 16:32:01 -0800 (PST)
Laurette Cisneros <laurette@nextbus.com>
index corruption?
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

Fri, 14 Feb 2003 01:16:10 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: index corruption? 