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

From: Jeffrey Baker <jwbaker(at)acm(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: In 7.3.1, will I be able to reindex toast?
Date: 2003-02-14 21:31:37
Message-ID: 20030214213137.GA12378@heat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

-jwb

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-14 21:32:59 Re: nodeRead: did not find '}' at end of plan node
Previous Message Jonathan Bartlett 2003-02-14 21:22:45 Re: Inquiry From Form [pgsql]