Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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


pgsql-performance by date

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

pgsql-admin by date

Next:From: Christian HacheDate: 2004-09-07 11:07:18
Subject: Asignasr permisos a usuarios
Previous:From: Tore HalsetDate: 2004-09-07 10:11:25
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group