Re: Disabling Triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Disabling Triggers
Дата
Msg-id 4427.1115826212@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Disabling Triggers  ("Mark Borins" <mark.borins@rigadev.com>)
Список pgsql-general
"Mark Borins" <mark.borins@rigadev.com> writes:
> Does anyone know if it is possible to run an update statement on a table and
> for only that statement disable the trigger on the table?

No, but why fire the update if not needed?  Make the trigger do
something like

    UPDATE foo SET boolcol = true WHERE ... AND not boolcol;

            regards, tom lane

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