"Eric Anderson Vianet SAO" <eric@vianet-express.com.br> writes:
> When I try to reindex a toast table with command �REINDEX TABLE
> pg_toast_16557' I receive following error message:
> ERROR: "pg_toast_16557" is a system table. call REINDEX under standalone
> postgres with -O -P options
> So I restart postmaster standalone (no -i option) and I receive same error.
Removing the -i option does not constitute a standalone backend. See
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-reindex.html
for a detailed description of the procedure you need to follow here.
(7.3 doesn't require this pushup anymore for toast tables, btw.)
regards, tom lane