Re: Can we have time based triggers in Postgresql?? - Mailing list pgsql-general

From Jan Wieck
Subject Re: Can we have time based triggers in Postgresql??
Date
Msg-id 4075574D.5000308@Yahoo.com
Whole thread Raw
In response to Re: Can we have time based triggers in Postgresql??  (Gregory Wood <gwood@ewebengine.com>)
List 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@Yahoo.com #


pgsql-general by date:

Previous
From: Mage
Date:
Subject: Re: eval in plpgsl
Next
From: Tom Lane
Date:
Subject: Re: Problem with pg_dump - reg.