Re: Index problem...

When I ran the query you specified I got relname of "pg_toast_16429.
When I ran the REINDEX TABLE pg_toast_16429 the system responds that
relation "pg_toast_16429" does not exist.

Carol

On May 22, 2008, at 1:02 PM, Tomeh, Husam wrote:

>
> You may want to try to reindex the associated toast table and see if
> that clears it up.
>
> To get the name of the associated toast table, you may run this query:
>
> select relname from pg_class where oid =
> (select reltoastrelid from pg_class where relname = 'maps');
>
> Then, reindex it.
>
> reindex table "toast table name" ..
>
> -------
>
> Regards,
> Husam
>
> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Carol Walter
> Sent: Thursday, May 22, 2008 9:42 AM
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
> **********************************************************************
> This message contains confidential information intended only for
> the use of the addressee(s) named above and may contain information
> that is legally privileged. If you are not the addressee, or the
> person responsible for delivering it to the addressee, you are
> hereby notified that reading, disseminating, distributing or
> copying this message is strictly prohibited. If you have received
> this message by mistake, please immediately notify us by replying
> to the message and delete the original message immediately thereafter.
>
> Thank you.
>
> FADLD Tag
> **********************************************************************