pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tim Perdue, The Des Moines City.net <tim@dmcity.net>
To: pgsql-sql@hub.org
Subject: Bug in Postgres 6.4?
Date: Sat, 23 Jan 1999 14:02:38 -0600
Message-ID: <011601be470b$53e80700$0b8c5aa5@timnt.weather.net> (raw)

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




Message-ID: <011601be470b$53e80700$0b8c5aa5@timnt.weather.net>
Permalink:  ../011601be470b$53e80700$0b8c5aa5@timnt.weather.net/
Also on:    postgresql.org/message-id/011601be470b$53e80700$0b8c5aa5@timnt.weather.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tim@dmcity.net, pgsql-sql@hub.org
  Subject: Re: Bug in Postgres 6.4?
  In-Reply-To: <011601be470b$53e80700$0b8c5aa5@timnt.weather.net>
  References: <011601be470b$53e80700$0b8c5aa5@timnt.weather.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox