Re: Order of evaluation in triggers for checks on inherited table partitions

Поиск
Список
Период
Сортировка
От Tarlika Elisabeth Schmitz
Тема Re: Order of evaluation in triggers for checks on inherited table partitions
Дата
Msg-id 20110527205242.1a832501@dick.coachhouse
обсуждение исходный текст
Ответ на Order of evaluation in triggers for checks on inherited table partitions  (Kevin Crain <kevin.crain1@gmail.com>)
Список pgsql-sql
On Fri, 27 May 2011 12:28:51 -0700
Kevin Crain <kevin.crain1@gmail.com> wrote:

>Is the order of evaluation for the trigger causing this error?

Are you aware that triggers are executed in alphabetical order?

I simply used RAISE to check the order of execution of my triggers:

RAISE NOTICE '% % % %: received %', TG_TABLE_NAME, TG_NAME, TG_WHEN,
TG_OP, NEW;



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

Предыдущее
От: Kevin Crain
Дата:
Сообщение: Order of evaluation in triggers for checks on inherited table partitions
Следующее
От: Piotr Czekalski
Дата:
Сообщение: Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way?