Bug in Postgres 6.4?
От | Tim Perdue, The Des Moines City.net |
---|---|
Тема | Bug in Postgres 6.4? |
Дата | |
Msg-id | 011601be470b$53e80700$0b8c5aa5@timnt.weather.net обсуждение исходный текст |
Список | 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
В списке pgsql-sql по дате отправления: