Re: Trigger with WHEN clause (WIP)

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Trigger with WHEN clause (WIP)
Дата
Msg-id 162867790910150745r17439da5n8f11dcdc808a5483@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Trigger with WHEN clause (WIP)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Trigger with WHEN clause (WIP)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2009/10/15 Tom Lane <tgl@sss.pgh.pa.us>:
> Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
>> I think there is a benefit to provide WHEN cluase at least
>> for compatibility with other DBMSs, even through we can move
>> the expressions into the body of trigger functions.
>
> This seems to me to be a lot of code to accomplish nothing useful.
> It will always be the case that any nontrivial logic has to be done
> inside the trigger.  And the compatibility argument is entirely
> pointless given the lack of compatibility in the trigger function
> itself.
>
> -1
>

I disagree. When I analysed speed of some operations, I found some
unwanted trigger calls should to slow down applications. I am for any
method, that could to decrease trigger calls.

Regards
Pavel Stehule


>                        regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Rejecting weak passwords
Следующее
От: Robert Haas
Дата:
Сообщение: Re: EXPLAIN BUFFERS