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

I see in the 7.3 release notes:

   Allow REINDEX of TOAST tables (Tom)


---------------------------------------------------------------------------

Jeffrey Baker wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073