I have run into this problem before. Both the toast index and toast
table are considered internal objects because they begin with pg_, and
thus you can't run reindex on them directly without running a single
process server. The workaround it to run reindex on the table that owns
the toast index/table, this will cause the toast index to also be rebuilt.
thanks,
--Barry
Tom Lane wrote:
>Mark Kirkwood <markir@slingshot.co.nz> writes:
>
>
>>With respect to the REINDEX workaround - having to re-start your server
>>single process for it is a bit fatal if you are 24/7 shop
>>
>>
>
>You don't have to do that for a TOAST table, do you? It should be okay
>to do the reindex in multiuser mode.
>
>(Now that I think about it, the code might think that a toast table is a
>system table, in which case we ought to loosen the check a little.)
>
>
regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>
>