On Feb 3, 2009, at 11:55 PM, Guy Rouillier wrote:
> Craig Ringer wrote:
>> An internal job scheduler with the ability to fire jobs on certain
>> events as well as on a fixed schedule could be particularly handy
>> in conjunction with true stored procedures that could explicitly
>> manage transactions.
>
> Craig, what kind of "events" are you thinking about? Triggers are
> already pieces of code that run upon "certain events", namely
> insert, update or delete events. What others do you have in mind?
What about LISTEN/NOTIFY events? That would be one way to create
autonomous transactions.
Cheers,
M