Re: [GENERAL] Does a 'stable' deferred trigger execution order exist? -> answer: yes

2004-08-17 Thread Frank van Vugt
> > Any execution order for regular triggers would be as good as any other > This is perhaps true for "cleanly designed" applications, but people > have requested that we nail down the execution order, and we have > responded by specifying that it's alphabetical within an event. I understand and a

Re: [GENERAL] Does a 'stable' deferred trigger execution order exist? -> answer: yes

2004-08-17 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: >> "Order in which they were defined"? Hmm, I thought we had agreed long >> since to trigger these things in alphabetical order. Something is wrong >> here. > Allow me to repeat and possibly clarify an earlier (personal) point of > interest: > Any exe

Re: [GENERAL] Does a 'stable' deferred trigger execution order exist?

2004-08-16 Thread Gaetano Mendola
Frank van Vugt wrote: 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. Mmm, yes, but are all the deferred triggers on the same event 'grouped'? What I'm thinking about is

Re: [GENERAL] Does a 'stable' deferred trigger execution order exist?

2004-08-16 Thread Frank van Vugt
> > 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. Mmm, yes, but are all the deferred triggers on the same event 'grouped'? What I'm thinking about is something

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

2004-08-16 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> 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 catalogu