Feature request: Truncate table - Mailing list pgsql-hackers

From Dann Corbit
Subject Feature request: Truncate table
Date
Msg-id D90A5A6C612A39408103E6ECDD77B82920CF51@voyager.corporate.connx.com
Whole thread Raw
Responses Re: Feature request: Truncate table
Re: Feature request: Truncate table
List pgsql-hackers
Deletion of data from a PostgreSQL table is very slow.

It would be nice to have a very fast delete like "truncate table."

Now, truncate is a very dangerous command because it is not logged (but
the same is true for other operations like bulk copy and select into).
So one needs to be careful how this command is granted.  The same damage
(accidental deletion of all data) can be done by drop table just as
easily.

I frequently have to do this right now in PostgreSQL, but I simply
emulate it by drop table/create table.


pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Integrating libpqxx
Next
From: Larry Rosenman
Date:
Subject: Re: Feature request: Truncate table