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

From Tim Smith
Subject Re: Delete rule does not prevent truncate
Date
Msg-id CA+HuS5E4JEYuP9eYDdFjZSngne-+goKDrDHRz7UMMo4RNhRdfw@mail.gmail.com
Whole thread Raw
In response to Re: Delete rule does not prevent truncate  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
>
> Just in case it has not been made obvious yet, rules are silently
> deprecated. They still exist because views depend on them, but it is
> generally considered best practices to not use them outside that realm.


Well, the manual doesn't seem to reflect that fact.

If that's how the developers feel about rules, i.e they can't be
bothered to make any changes to the rules code any more, no matter how
minor (e.g. this TRUNCATE issue), then you should explicitly state in
the manual that they are depreciated, and stop making stupid
statements like "so if many rows are affected in one statement, a rule
issuing one extra command is likely to be faster than a trigger" that
encourage people to use rules !


pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: Connections closing due to "terminating connection due to administrator command"
Next
From: Tim Smith
Date:
Subject: Re: Delete rule does not prevent truncate