Re: Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?
Дата
Msg-id 13267.1092667005@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Ответы Re: Does a 'stable' deferred trigger execution order exist?  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Список pgsql-general
Frank van Vugt <ftm.van.vugt@foxi.nl> writes:
> If during a transaction a number of deferred triggers are fired, what will be
> their execution order upon the commit?

Should be alphabetical within each triggering event, IIRC.

> Also, are the fire-events of deferred triggers kept in a system catalogue
> somewhere,

No.  They're in a list in memory.

            regards, tom lane

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

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: Thousands of parallel connections
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Thousands of parallel connections