Re: Pet Peeves? - Mailing list pgsql-general

From Craig Ringer
Subject Re: Pet Peeves?
Date
Msg-id 49892302.8020109@postnewspapers.com.au
Whole thread Raw
In response to Re: Pet Peeves?  (Guy Rouillier <guyr-ml1@burntmail.com>)
Responses Re: Pet Peeves?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Pet Peeves?  ("Karsten Hilbert" <Karsten.Hilbert@gmx.net>)
Re: Pet Peeves?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-general
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?

That's a good point, actually. I can't think of much you can't do with a
trigger (SECURITY DEFINER if necessary) on a table. Not thinking straight.

--
Craig Ringer

pgsql-general by date:

Previous
From: Guy Rouillier
Date:
Subject: Re: Pet Peeves?
Next
From: Scott Marlowe
Date:
Subject: Re: Pet Peeves?