Re: Docs - Plpgsql trigger example auditing changes into another table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Docs - Plpgsql trigger example auditing changes into another table
Дата
Msg-id 1215.1102020216@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Docs - Plpgsql trigger example auditing changes into another table  (Mark Kirkwood <markir@coretech.co.nz>)
Ответы Re: Docs - Plpgsql trigger example auditing changes into  (Mark Kirkwood <markir@coretech.co.nz>)
Список pgsql-patches
Mark Kirkwood <markir@coretech.co.nz> writes:
> This patch adds another plpgsql trigger example to the chapter. It uses
> the emp table again, but shows how to audit changes into another table
> (emp_audit).

Should be an AFTER trigger, else you may be recording the wrong data, or
even an event that didn't happen at all.

            regards, tom lane

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Docs - Plpgsql trigger example auditing changes into another table
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Docs - Plpgsql trigger example auditing changes into