index corruption?

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: index corruption?
Date: 2003-02-14 00:32:01
Message-ID: Pine.LNX.4.44.0302131629150.7275-100000@visor.corp.nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-02-14 00:38:19 Re: java access to the backend (non jdbc)?
Previous Message Shahbaz Chaudhary 2003-02-14 00:25:03 Re: java access to the backend (non jdbc)?