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: (view raw, whole thread or download thread mbox)
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.


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

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