Re: [HACKERS] Trigger concurrent execution

2014-05-16 Thread Blagoj Petrushev
Hi, Thanks all for being patient, apparently I didn't quite understand the norms of trigger execution. On 16 May 2014 07:55, Craig Ringer wrote: > On 05/16/2014 08:06 AM, Blagoj Petrushev wrote: >> Hi, >> >> I'm thinking of an extension to trigger functionality like this: >> >> CREATE TRIGGER tr

Re: [HACKERS] Trigger concurrent execution

2014-05-15 Thread Craig Ringer
On 05/16/2014 08:06 AM, Blagoj Petrushev wrote: > Hi, > > I'm thinking of an extension to trigger functionality like this: > > CREATE TRIGGER trigger_name > AFTER event > ON table > CONCURRENTLY EXECUTE PROCEDURE trigger_fc > > This would call the trigger after the end of the transac

Re: [HACKERS] Trigger concurrent execution

2014-05-15 Thread David G Johnston
Blagoj Petrushev wrote > Hi, > > I'm thinking of an extension to trigger functionality like this: > > CREATE TRIGGER trigger_name > AFTER event > ON table > CONCURRENTLY EXECUTE PROCEDURE trigger_fc > > This would call the trigger after the end of the transaction. > > The following

[HACKERS] Trigger concurrent execution

2014-05-15 Thread Blagoj Petrushev
Hi, I'm thinking of an extension to trigger functionality like this: CREATE TRIGGER trigger_name AFTER event ON table CONCURRENTLY EXECUTE PROCEDURE trigger_fc This would call the trigger after the end of the transaction. The following is a use-case, please tell me if I'm doing it w