| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 ! |