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

Re: Time-based trigger/procedure

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Time-based trigger/procedure
Date: 2009-04-19 11:08:47
Message-ID: gsf0nv$fv4$1@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-novice
On 2009-04-09, André Silva <andre(dot)beat(at)gmail(dot)com> wrote:
> --0015174c0df051ba710467141cad
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable
>
> I have a table that defines a programmed service that does something
> automatically every time interval (days, weeks, months) from a beginning
> date to a ending date.
> How can I do this in postgresql? I have no access to the OS,
> so cron is not an option.

timed events need OS support.

what do you have access to ? 
If you have shell access to the server
(or the ability to execute scripts on it) you can use the crontab
command to create cron tasks that run in your name

else you may need to set up a cron job on some other server that
connects to your database and runs the stuff for you.

In response to

pgsql-novice by date

Next:From: Juan Jose De LeonDate: 2009-04-20 19:27:42
Subject: PostgreSQL not working?
Previous:From: David SaraciniDate: 2009-04-15 01:58:06
Subject: newbie question: bytea v. large objects

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