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
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? |