Re: In 7.3.1, will I be able to reindex toast?

On Fri, Feb 14, 2003 at 09:36:44AM -0800, Jeffrey Baker wrote:
> I am considering moving to 7.3 from 7.2.  I have the
> obnoxious toast index growth problem of doom.  In 7.2 I am
> not allowed to reindex toast tables, because they are of
> type 't'.  How smug :)
>
> The problem is I don't want to move to 7.3 unless I can be
> certain this is going to work.  There are many incompatible
> changes in 7.3, and I will need to audit tens of thousands
> of lines of queries before I can make the move.  Can someone
> reassure me?  It says you can reindex toast tables in the
> changelog, but ...
>
> Also I assume REINDEX in 7.3 still requires exclusive
> access?  That could be a bummer.

In partial resposne to my own question, I've found that
7.3.2 will not reindex TOAST tables explicitly:

rupert=> reindex table pg_toast_12550267;
ERROR:  Relation "pg_toast_12550267" does not exist

But does it reindex the TOAST tables if I reindex the
related table?

-jwb