X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 509B35E472E; Tue, 7 Sep 2004 12:13:00 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49755-10; Tue, 7 Sep 2004 11:12:57 +0000 (GMT) Received: from honorio.sinectis.com.ar (honorio.sinectis.com.ar [216.244.192.201]) by svr1.postgresql.org (Postfix) with ESMTP id DDEE45E470B; Tue, 7 Sep 2004 12:12:53 +0100 (BST) Received: by honorio.sinectis.com.ar (Postfix, from userid 99) id 23BA56C4EA; Tue, 7 Sep 2004 08:12:58 -0300 (GMT+3) Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 X-Mailer: Sinectis Webmail 5.6.16-1.5.1 From: G u i d o B a r o s i o To: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org Subject: Re: TOAST tables, cannot truncate Reply-To: gbarosio@uolsinectis.com.ar Message-Id: <20040907111258.23BA56C4EA@honorio.sinectis.com.ar> Date: Tue, 7 Sep 2004 08:12:58 -0300 (GMT+3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/63 X-Sequence-Number: 14766 Ok, problem solved. A previous ALTER TABLE DROP COLUMN over this table was performed. By some reason, truncate didn't work then. Would like to know why...it does not seems to be a very frequent problem, due to the fact I only found one chat on the mailing lists talking about this issue, and was hard to find :( ! A dump of the table schema, passed to the psql command (cat table_dump.sql | psql xxx) worked fine. TRUNCATE is now available. Thanks. Guido > Sorry for crossposting, didn't know where to post. > > Any hint/help on this?! > > db_postgres1=# truncate ref_v2_drs_valid_product ; > ERROR: expected both swapped tables to have TOAST tables > > I need to truncate this table, this is the first time I see this error. > > Regards, > Guido > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend