Received: from slip3.raccoon.com (slip3.raccoon.com [165.90.134.130]) by hub.org (8.9.1/8.9.1) with ESMTP id PAA13370 for ; Sat, 23 Jan 1999 15:10:01 -0500 (EST) (envelope-from tim@dmcity.net) Received: from timnt (tim.desmoinesnet.com [165.90.140.11]) by slip3.raccoon.com (8.8.7/8.8.7) with SMTP id OAA02017 for ; Sat, 23 Jan 1999 14:15:13 -0600 Message-ID: <011601be470b$53e80700$0b8c5aa5@timnt.weather.net> Reply-To: "Tim Perdue, The Des Moines City.net" From: "Tim Perdue, The Des Moines City.net" To: Subject: Bug in Postgres 6.4? Date: Sat, 23 Jan 1999 14:02:38 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 I'm running 6.4 on a LinuxPPC box. I have an 8MB table of mailing list archives, mostly big TEXT fields. I was trying to create a index on the text field AFTER the table was populated (shouldn't cause problems, right?). And I got these errors: >CREATE INDEX idx_mail_body ON tbl_mail_archive (fld_mail_body); java.sql.SQLException: FATAL 1: btree: failed to add item to the page in _bt_sort (2) java.lang.Throwable(java.lang.String) java.lang.Exception(java.lang.String) java.sql.SQLException(java.lang.String) postgresql.ResultSet postgresql.Connection.ExecSQL(java.lang.String) boolean postgresql.Statement.execute(java.lang.String) int postgresql.Statement.executeUpdate(java.lang.String) void com.geocrawler.common.util.SQLInterface.buttonPerformSQL_ActionEvents() void com.geocrawler.common.util.SQLInterface.connEtoC1() void com.geocrawler.common.util.SQLInterface.actionPerformed(java.awt.event.Actio nEvent) void java.awt.Button.processActionEvent(java.awt.event.ActionEvent) void java.awt.Button.processEvent(java.awt.AWTEvent) void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent) void java.awt.Component.dispatchEvent(java.awt.AWTEvent) void java.awt.EventDispatchThread.run() Using PSQL I tried to drop the index: db_domain-> DROP INDEX idx_mail_body; ERROR: parser: parse error at or near "drop" db_domain=> CREATE INDEX idx_mail_body ON tbl_mail_archive (fld_mail_body); ERROR: cannot create idx_mail_body db_domain=> DROP INDEX idx_mail_body; ERROR: index "idx_mail_body" nonexistent