Thursday, May 22, 2008

[ADMIN] Index problem...

Greetings...

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: