Re: Can we have time based triggers in Postgresql??

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Gregory Wood <gwood(at)ewebengine(dot)com>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: Can we have time based triggers in Postgresql??
Date: 2004-04-08 13:44:45
Message-ID: 4075574D.5000308@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gregory Wood wrote:

> Jan Wieck wrote:
>> Gregory Wood wrote:
>>> The only real advantage I see are for those people in hosting
>>> environments that don't really have access to cron. I suppose it's
>>> also valuable in making your scripts more portable as you wouldn't
>>> need to make further alterations to the system beyond restoring a
>>> database backup or whatnot.
>>
>> and as soon as one would implement such stuff the users will be asking
>> "and how do I execute shell commands from inside the DB?". Now that
>> would be good thing. In preparation for that we should make the
>> postmaster run under root, so that the pgcron functionality can start
>> those external commands as any user! </irony>
>
> I think you stretched well beyond the scope of my comments, but since

Sure did I and on purpose too, because when you offer "them" the small
finger, you find yourself easily dismembered entirely!

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-04-08 14:01:35 Re: Problem with pg_dump - reg.
Previous Message Mage 2004-04-08 13:07:21 Re: eval in plpgsl