Re: What Is The Firing Order?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What Is The Firing Order?
Дата
Msg-id 4321.999894001@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: What Is The Firing Order?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: What Is The Firing Order?
Список pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> The order of execution of a set of triggers is ascending by value
>> of their timestamp of creation in their descriptors, such that the
>> oldest trigger executes first.

> Yep, that would be a pretty strong vote for OID order.

Au contraire: OID wraparound would cause us to violate the spec.
If we want to follow the spec here, then I think we'd need to add
a creation-timestamp column to pg_trigger, and sort on that.

            regards, tom lane

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

Предыдущее
От: Alex Pilosov
Дата:
Сообщение: Re: moving char() to varchar()
Следующее
От: Tom Lane
Дата:
Сообщение: Re: moving char() to varchar()