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.
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.
pgsql-admin by date
|Next:||From: Tomeh, Husam||Date: 2008-05-22 17:02:10|
|Subject: Re: Index problem...|
|Previous:||From: Amit jain||Date: 2008-05-22 13:47:45|
|Subject: Error while executing pg_dump "invalid memory alloc request size 4294967293"|