Re: Delete rule does not prevent truncate - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Delete rule does not prevent truncate
Date
Msg-id 55AFB7A8.6010106@commandprompt.com
Whole thread Raw
In response to Re: Delete rule does not prevent truncate  (Tim Smith <randomdev4+postgres@gmail.com>)
Responses Re: Delete rule does not prevent truncate  (Geoff Winkless <pgsqladmin@geoff.dj>)
List 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.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Delete rule does not prevent truncate
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Delete rule does not prevent truncate