I'm getting an error. The error says...
places=# REINDEX INDEX maps_map_id_seq;
ERROR: "maps_map_id_seq" is not an index
places=# SELECT * FROM maps;
ERROR: missing chunk number 0 for toast value 131343627
I have tried reindexing the index, the table, and the database. I
continue to get this error. What can I do to recover from this.
Carol Walter
PS Let me say that I know this is my fault. This index is very
bloated. Yesterday, I tried to vacuum. I got errors because
max_fsm_pages what set at a number that was too small.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
No comments:
Post a Comment