"Eric Anderson Vianet SAO" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
