Re: [PERFORM] [ADMIN] TOAST tables, cannot truncate

2004-09-07 Thread Tom Lane
G u i d o B a r o s i o <[EMAIL PROTECTED]> writes: > 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 ch

Re: [ADMIN] TOAST tables, cannot truncate

2004-09-07 Thread G u i d o B a r o s i o
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

[ADMIN] TOAST tables, cannot truncate

2004-09-07 Thread G u i d o B a r o s i o
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 --