Re: yet pg_toast reindex

"Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)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