Re: Delete rule does not prevent truncate

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tim Smith <randomdev4+postgres(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delete rule does not prevent truncate
Date: 2015-07-22 15:32:56
Message-ID: 55AFB7A8.6010106@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 07/22/2015 06:13 AM, Tim Smith wrote:
> Melvin,
>
> May I point out that the manual states :
> "TRUNCATE quickly removes all rows from a set of tables. It has the same
> effect as an unqualified DELETE on each table"

This is actually wrong. The end result is the same but it does not in
any way have the same effect. And I will submit a patch.

TRUNCATE is NOT DELETE.

Sincerely,

JD

--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2015-07-22 15:39:24 Re: Delete rule does not prevent truncate
Previous Message Adrian Klaver 2015-07-22 13:38:09 Re: Delete rule does not prevent truncate