Re: [PERFORM] TOAST tables, cannot truncate

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gbarosio(at)uolsinectis(dot)com(dot)ar
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] TOAST tables, cannot truncate
Date: 2004-09-07 14:16:28
Message-ID: 103.1094566588@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

G u i d o B a r o s i o <gbarosio(at)uolsinectis(dot)com(dot)ar> 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 chat on the mailing lists talking about this issue, and was hard to find :( !

http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/cluster.c

(note: cvsweb seems mighty slow today, but it is working...)

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry LeVan 2004-09-07 15:42:55 Selecting columns by position?
Previous Message Goulet, Dick 2004-09-07 12:21:39 Re: Asignasr permisos a usuarios

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2004-09-07 14:30:54 Re: The usual sequential scan, but with LIMIT !
Previous Message Tom Lane 2004-09-07 13:47:47 Re: The usual sequential scan, but with LIMIT !