Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: In 7.3.1, will I be able to reindex toast?
Date
Msg-id 11605.1045261509@sss.pgh.pa.us
Whole thread Raw
In response to Re: In 7.3.1, will I be able to reindex toast?  (Jeffrey Baker <jwbaker@acm.org>)
Responses Re: In 7.3.1, will I be able to reindex toast?  (Jeffrey Baker <jwbaker@acm.org>)
List pgsql-general
Tree view 
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


            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "iscachable" functions
Next
From: Clarence Gardner
Date:
Subject: Lots o' I/O