Re: Delete rule does not prevent truncate

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tim Smith <randomdev4(at)gmail(dot)com>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delete rule does not prevent truncate
Date: 2015-07-23 18:05:52
Message-ID: 20150723180552.GF21169@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2015-07-23 12:57:20 +0100, Tim Smith wrote:
> Thus, I should not have to use a trigger for TRUNCATE because the "each
> row" concept does not apply. Plus it makes perfect sense to want to
> transform the truncate command and transform into ignore

That'd entirely defeat the point of TRUNCATE being fast.

Either way, this isn't going to change, so it seems a bit pointless to
continue arguing around it circles.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-07-23 18:09:54 Re: Delete rule does not prevent truncate
Previous Message Adrian Klaver 2015-07-23 18:02:06 Re: Using the database to validate data