Thread: reindex toast table

reindex toast table

From
"Eric Anderson Vianet SAO"
Date:
when i try to reindex a toast table i´ve got an error
 
reindex table pg_toast.pg_toast_163219;
error: parse error at or near "." 
 
before to write to list i´v read some documentation and don´t notice what is wrong.
 
tnx
 
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO

Re: reindex toast table

From
Tom Lane
Date:
"Eric Anderson Vianet SAO" <eric@vianet-express.com.br> writes:
> when i try to reindex a toast table i=B4ve got an error
> reindex table pg_toast.pg_toast_163219;
> error: parse error at or near "."=20

Pre-7.3 backend, perhaps?  There are no schemas before 7.3, thus no
"pg_toast" schema to specify.

            regards, tom lane

Re: reindex toast table

From
"Eric Anderson Vianet SAO"
Date:
i-m using postgres 7.2

tnx

Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
Cc: "PostgreSQL general" <pgsql-general@postgresql.org>
Sent: Monday, June 02, 2003 3:04 PM
Subject: Re: [GENERAL] reindex toast table


> "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> writes:
> > when i try to reindex a toast table i=B4ve got an error
> > reindex table pg_toast.pg_toast_163219;
> > error: parse error at or near "."=20
>
> Pre-7.3 backend, perhaps?  There are no schemas before 7.3, thus no
> "pg_toast" schema to specify.
>
> regards, tom lane