Skip site navigation (1) Skip section navigation (2)

Re: Pet Peeves?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-02-04 05:11:45
Message-ID: dcc563d10902032111m13093f52i743bf020e1cc5cac@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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 ClemensDate: 2009-02-04 05:51:45
Subject: Re: problem converting database to UTF-8
Previous:From: Craig RingerDate: 2009-02-04 05:09:22
Subject: Re: Pet Peeves?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group