Re: Yet another "drop table vs delete" question - Mailing list pgsql-general

From Christophe
Subject Re: Yet another "drop table vs delete" question
Date
Msg-id 2015F73A-6A49-4178-ABA3-859D88E10CE4@thebuild.com
Whole thread Raw
In response to Re: Yet another "drop table vs delete" question  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Yet another "drop table vs delete" question
List pgsql-general
On Apr 21, 2009, at 12:28 PM, Peter Eisentraut wrote:
> Yes, but if you are asking that question, you probably really want
> to use
> TRUNCATE.

The advantage of DROP TABLE being, of course, that DROP TABLE is
transactionally-safe, while TRUNCATE is not.

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Yet another "drop table vs delete" question
Next
From: Stephen Frost
Date:
Subject: Re: PostgreSQL versus MySQL for GPS Data