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

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: gsstark(at)mit(dot)edu (Greg Stark)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can we have time based triggers in Postgresql??
Date: 2004-04-07 15:04:31
Message-ID: 200404071504.i37F4WHH025782@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> There's no reason you couldn't write a cron daemon that retrieved its list of
> jobs from an SQL database. In fact we discussed doing exactly this at my last
> job. I expect others have thought of the same idea and wouldn't be surprised
> if it existed by now.

Is there (or would we need) a way to specify access privileges for such
a daemon in pg_hba.conf, and would that allow controlling the access
privileges for each job or the user who sets it? (ISP's would want
tight controls here.)

If the answer to both questions can be 'yes', this probably gives us most
of what the Oracle jobs feature does.
--
Mike Nolan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2004-04-07 15:13:29 \? not working in psql
Previous Message Tom Lane 2004-04-07 15:02:26 Re: More aggregate functions?