Re: Triggers on columns

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема Re: Triggers on columns
Дата
Msg-id 20090903161742.335F.52131E4D@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Triggers on columns  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
Ответы Re: Triggers on columns  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
KaiGai Kohei <kaigai@ak.jp.nec.com> wrote:

> Itagaki-san, isn't it more suitable to check rte->modifiedCols
> than heap_tuple_attr_equals()? Although, this information is
> not delivered to executor...

I'd like to check conditions by comparing actual values but not
a target of UPDATE statement because I think almost user expects
the former behavior. Unmodified UPDATE-targets are common case
if we use a framework that generates SQL statements internally.

Anyway, we need to compare the actual values if we want to treat
NEW value modifed by another trigger correctly.


Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




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

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: Re: Triggers on columns
Следующее
От: Magnus Hagander
Дата:
Сообщение: Fwd: Copy out wording