reindex toast table
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
"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
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
Show quoted text
"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 "."=20Pre-7.3 backend, perhaps? There are no schemas before 7.3, thus no
"pg_toast" schema to specify.regards, tom lane