Re: Audit Trigger puzzler

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Audit Trigger puzzler
Дата
Msg-id 1251486460.4839.1458.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Audit Trigger puzzler  (David Kerr <dmk@mr-paradox.net>)
Ответы Re: Audit Trigger puzzler
Список pgsql-general
On Fri, 2009-08-28 at 08:50 -0700, David Kerr wrote:

> so, is there a way in a trigger to know if edited_by is expressly
> being  set in the update statement? it seems like if I can know that,
> then i should be able to figure it out.

No, but you could use a before trigger to reset the value to NULL prior
to each update, then your after trigger would work.

--
 Simon Riggs           www.2ndQuadrant.com


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

Предыдущее
От: Edwin Plauchu
Дата:
Сообщение: Re: details locks
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: High load on commit after important schema changes