Re: Delete rule does not prevent truncate

From: Tim Smith <randomdev4+postgres(at)gmail(dot)com>
To: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delete rule does not prevent truncate
Date: 2015-07-23 07:06:19
Message-ID: CA+HuS5FeH1KoyRpG29Avn=mAXZjFEj+CmrFyNM=kmkEG9LbwbQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

So tell me guys, instead of bashing away at the fact I only quoted
half a sentence or whatever, how about you answer the following :

What exactly is was the design decision that lead to TRUNCATE being
supported by triggers but not by rules ?

I suspect that TRUNCATE was added to triggers because some dev thought
it would be a neat idea, and it was never implemented in rules as a
result of an accidental omission for <whatever reason> rather than a
deliberate design constraint.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2015-07-23 08:19:00 Re: Delete rule does not prevent truncate
Previous Message Dean Rasheed 2015-07-22 21:04:02 Re: [9.5] next question: rls and indexes