TOAST tables, cannot truncate

From: G u i d o B a r o s i o <gbarosio(at)uolsinectis(dot)com(dot)ar>
To: pgsql-admin(at)postgresql(dot)org
Cc: pgsql-performance(at)postgresql(dot)org
Subject: TOAST tables, cannot truncate
Date: 2004-09-07 10:41:07
Message-ID: 20040907104107.DAC576C4F2@honorio.sinectis.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

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

Browse pgsql-admin by date

  From Date Subject
Next Message Christian Hache 2004-09-07 11:07:18 Asignasr permisos a usuarios
Previous Message Tore Halset 2004-09-07 10:11:25

Browse pgsql-performance by date

  From Date Subject
Next Message G u i d o B a r o s i o 2004-09-07 11:12:58 Re: TOAST tables, cannot truncate
Previous Message Pierre-Frédéric Caillaud 2004-09-07 06:51:54 Re: The usual sequential scan, but with LIMIT !