Re: Delete rule does not prevent truncate
От | Melvin Davidson |
---|---|
Тема | Re: Delete rule does not prevent truncate |
Дата | |
Msg-id | CANu8Fixq3_-OZgCHqrz_-tOfkm4EmL_Qq225D+grofVtW=MK-g@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Delete rule does not prevent truncate (Tim Smith <randomdev4@gmail.com>) |
Список | pgsql-general |
For crying out loud GET OVER IT! You've been given a very reasonable and quick solution to your problem.
You can either On Fri, Jul 24, 2015 at 5:27 AM, Tim Smith <randomdev4@gmail.com> wrote:
On 23 July 2015 at 19:25, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> stick to triggers, they're faster
Erm, not according to your beloved manual !!!
38.7. Rules Versus Triggers
" a rule issuing one extra command is likely to be faster than a trigger"
"The summary is, rules will only be significantly slower than triggers
if their actions result in large and badly qualified joins, a
situation where the planner fails."
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

В списке pgsql-general по дате отправления: