Re: Delete rule does not prevent truncate

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delete rule does not prevent truncate
Date: 2015-07-22 15:42:10
Message-ID: CAEzk6fd7OMvvnkEeLDJVG39Hgzt3ggfkw9Ew_SFoRXJ=p+Y0hA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 22 July 2015 at 16:32, Joshua D. Drake <jd(at)commandprompt(dot)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.

> And I will submit a patch.
>


As long as the patch is ", although your attention should be brought to the
caveats listed below, since you're obviously
​incapable of​
realis
​ing​
that there's a page and a half of
​information
beneath this sentence"?

> TRUNCATE is NOT DELETE.
>

​I don't think anyone is suggesting that it is.​

​Otherwise there wouldn't be much point having it.​

​Geoff​

In response to

Responses

Browse pgsql-general by date

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