Re: Pet Peeves? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Pet Peeves?
Date
Msg-id dcc563d10902032111m13093f52i743bf020e1cc5cac@mail.gmail.com
Whole thread Raw
In response to Re: Pet Peeves?  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
On Tue, Feb 3, 2009 at 10:09 PM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
> 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.

other than schedule it to go off at certain times, not much you can't do.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Pet Peeves?
Next
From: Schwaighofer Clemens
Date:
Subject: Re: problem converting database to UTF-8