Re: PostgreSQL trigger execution order
От | Sebastian Ritter |
---|---|
Тема | Re: PostgreSQL trigger execution order |
Дата | |
Msg-id | 20100706100524.GA1254@campbell-lange.net обсуждение исходный текст |
Ответ на | Re: PostgreSQL trigger execution order (Alban Hertroys <dalroi@solfertje.student.utwente.nl>) |
Ответы |
Re: PostgreSQL trigger execution order
|
Список | pgsql-general |
Hi Alban, Thanks again for your response. On Tue, Jul 06, 2010 at 11:57:14AM +0200, Alban Hertroys wrote: > On 6 Jul 2010, at 11:33, Sebastian Ritter wrote: > > > In what order will the triggers be executed? > > > > Will it be: > > > > INSERT row > > INVOKE TRIGGER A (First call) > > INVOKE TRIGGER B (First call) -> INSERT row > > INVOKE TRIGGER A (Second call) > > INVOKE TRIGGER B (let say no new insert) > > INVOKE TRIGGER C (Second call) > > INVOKE TRIGGER D (Second call) > > INVOKE TRIGGER C (First call) > > INVOKE TRIGGER D (First call) > > > > Or will it be: > > > > INVOKE TRIGGER A (First call) > > INVOKE TRIGGER B (First call) -> INSERT row and wait... > > Wait for what exactly? You seem to expect some kind of external event here. 'wait...' for the first invocation of trigger C and D to finish before starting the second round of invocations A-D. > > > INVOKE TRIGGER C (First call) > > INVOKE TRIGGER D (First call) > > > > INVOKE TRIGGER A (Second call) > > INVOKE TRIGGER B (let say no new insert) > > INVOKE TRIGGER C (Second call) > > INVOKE TRIGGER D (Second call) > > As you suggested in your response, I think the first scenario is happening. Regards, Seb
В списке pgsql-general по дате отправления: