On Tue, Feb 3, 2009 at 10:09 PM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)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.
In response to
pgsql-general by date
| Next: | From: Schwaighofer Clemens | Date: 2009-02-04 05:51:45 |
| Subject: Re: problem converting database to UTF-8 |
| Previous: | From: Craig Ringer | Date: 2009-02-04 05:09:22 |
| Subject: Re: Pet Peeves? |