Re: TOAST tables, cannot truncate - Mailing list pgsql-admin

From G u i d o B a r o s i o
Subject Re: TOAST tables, cannot truncate
Date
Msg-id 20040907111258.23BA56C4EA@honorio.sinectis.com.ar
Whole thread Raw
In response to TOAST tables, cannot truncate  (G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>)
Responses Re: [PERFORM] TOAST tables, cannot truncate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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,
dueto 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


pgsql-admin by date:

Previous
From: G u i d o B a r o s i o
Date:
Subject: TOAST tables, cannot truncate
Next
From: "Christian Hache"
Date:
Subject: Asignasr permisos a usuarios