Error: missing chunk number for toast value

[Kevin Kempter <cs_dba@xxxxxxxxxxxxxxxxxxx>]

Hi All;

We're seeing this error in our 8.3.9 database:

# select * from comments;
ERROR:  missing chunk number 0 for toast value 1274882 in pg_toast_49234


I tried this:

# reindex table pg_toast.pg_toast_49234;
REINDEX


but the error still persists.

Thoughts?

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin