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:39:24
Message-ID: 55AFB92C.6000107@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 07/22/2015 06:24 AM, Tim Smith wrote:
>
> Adrian,
>
> It still doesn't make much sense, especially as given the rather
> obscure and questionable design decision of allowing triggers to refer
> to truncate ops, but not allowing rules to refer to truncate ops !!!

Actually it makes perfect sense because rules are a feature for
compatibility (at this point) more than anything else. They are slower
than triggers, less flexible and widely considered something you only
use in very rare circumstances.

That and of course, patches are accepted if you feel it is a feature
worth having.

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

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2015-07-22 15:42:10 Re: Delete rule does not prevent truncate
Previous Message Joshua D. Drake 2015-07-22 15:32:56 Re: Delete rule does not prevent truncate