Re: HOWTO : plpgsql stored function spawn cron job that will run other stored functions

On Dec 21, 2007, at 7:43 AM, Robert M. Bernabe wrote:

> Thanks for the reply. PGAgent is one option I've found but I was
> hoping somebody can suggest another way to do this that would just
> use plpgsql and maybe cron. Another method perhaps that is not
> dependent  PGAgent...


You can't do this in plpgsql alone. There is no built-in facility to
make something run at some interval. If you use cron, all you need to
do is have it call your function from a shell script. Something like:

psql -d database -U user -c "select my_store_function()"




John DeSoi, Ph.D.