Re: Yet another "drop table vs delete" question

From: Christophe <xof(at)thebuild(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Yet another "drop table vs delete" question
Date: 2009-04-21 19:31:23
Message-ID: 2015F73A-6A49-4178-ABA3-859D88E10CE4@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Morton 2009-04-21 19:34:12 Re: round behavior differs between 8.1.5 and 8.3.7
Previous Message Alvaro Herrera 2009-04-21 19:30:06 Re: Yet another "drop table vs delete" question