Re: In 7.3.1, will I be able to reindex toast? - Mailing list pgsql-general

From Jeffrey Baker
Subject Re: In 7.3.1, will I be able to reindex toast?
Date
Msg-id 20030214223821.GA15615@heat
Whole thread Raw
In response to Re: In 7.3.1, will I be able to reindex toast?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Feb 14, 2003 at 05:25:09PM -0500, Tom Lane wrote:
> Jeffrey Baker <jwbaker@acm.org> writes:
> > 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
>
> Yes it will, if you name them correctly:
>
> regression=# reindex table pg_toast.pg_toast_840608;
> REINDEX

Thank you! -jwb

pgsql-general by date:

Previous
From: John Smith
Date:
Subject: parameters in views
Next
From: Medi Montaseri
Date:
Subject: pg_stat_user_tables