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

Jeffrey Baker wrote:
> On Fri, Feb 14, 2003 at 04:05:12PM -0500, Bruce Momjian wrote:
> >
> > I see in the 7.3 release notes:
> >
> > Allow REINDEX of TOAST tables (Tom)
>
> Thank you Bruce, I mentioned that in my opening email. The
> question is, does it *actually* work, and if so how do you
> invoke it. Demonstrably, you cannot invoke reindex on an
> actual toast table, because it fails with an error.
>
> So you invoke REINDEX on your user table and the TOAST is
> automatically reindexed as well?

No, TOAST tables have to be reindexes separately. It does require an
exclusive lock.

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