ERROR: invalid overflow block number 13947

From: "Michael B(dot) Babakov" <M(dot)Babakov(at)sochi(dot)net(dot)ru>
To: pgsql-admin-owner(at)postgresql(dot)org
Subject: ERROR: invalid overflow block number 13947
Date: 2006-06-30 17:21:38
Message-ID: 44A55DA2.8060304@sochi.net.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

During execution of query
UPDATE links SET weight = weight + (0.002972378315) WHERE ot='38933058' AND
k='39267613'

I got the error: ERROR: invalid overflow block number 13947

The "links" table have two HASH indexes and one BTREE index.
Reindexing of "links" table is in progress. But I'm not sure will this resolve
this problem ?
PgSQL 8.1.3 on FreeBSD

Good luck,
Michael

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-06-30 18:07:12 Re: auto vacuum doens't appear to be working
Previous Message Tom Lane 2006-06-30 15:09:14 Re: auto vacuum doens't appear to be working