Bug in Postgres 6.4?

From: "Tim Perdue, The Des Moines City(dot)net" <tim(at)dmcity(dot)net>
To: <pgsql-sql(at)hub(dot)org>
Subject: Bug in Postgres 6.4?
Date: 1999-01-23 20:02:38
Message-ID: 011601be470b$53e80700$0b8c5aa5@timnt.weather.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message David Hartwig 1999-01-23 23:06:09 Re: [SQL] Select... RANGE?
Previous Message Tim Perdue, The Des Moines City.net 1999-01-23 19:52:47 Select... RANGE?