X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1731730EFC2 for ; Tue, 17 Jun 2003 14:56:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 35546-08 for ; Tue, 17 Jun 2003 11:55:51 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 493F830EFA7 for ; Tue, 17 Jun 2003 11:55:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5HEtpU6012766; Tue, 17 Jun 2003 10:55:52 -0400 (EDT) To: "Eric Anderson Vianet SAO" Cc: pgsql-sql@postgresql.org Subject: Re: yet pg_toast reindex In-reply-to: <00db01c334cb$4d731920$0701a8c0@netterm> References: <00db01c334cb$4d731920$0701a8c0@netterm> Comments: In-reply-to "Eric Anderson Vianet SAO" message dated "Tue, 17 Jun 2003 09:23:47 -0300" Date: Tue, 17 Jun 2003 10:55:51 -0400 Message-ID: <12765.1055861751@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/182 X-Sequence-Number: 13940 "Eric Anderson Vianet SAO" 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