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

On 07/22/2015 08:42 AM, Geoff Winkless wrote:
> On 22 July 2015 at 16:32, Joshua D. Drake <jd@commandprompt.com
> <mailto:jd@commandprompt.com>>wrote:
>
>     This is actually wrong. The end result is the same but it does not
>     in any way have the same effect.
>
> ​
> "in any way"? ​
> ​I'd say in the primary way it has the same effect: all rows are removed
> from the table.

Thus the end result is the same as I said but the in practice effect is
quite different from a visibility, maintenance and programmability
perspective.

>
>     TRUNCATE is NOT DELETE.
>
>
> ​I don't think anyone is suggesting that it is.​

Except Tim Smith who started this thread.

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.