Re: "trigger"ing a procedure every X minutes - Mailing list pgsql-general

From Len Morgan
Subject Re: "trigger"ing a procedure every X minutes
Date
Msg-id 00f001c0eedf$20babac0$0908a8c0@H233.bstx.cc
Whole thread Raw
In response to "trigger"ing a procedure every X minutes  (Fran Fabrizio <ffabrizio@Exchange.WebMD.net>)
List pgsql-general
>> It's certainly not a big deal to use the cron, I just thought maybe
someone
>> had experimented with an internal mechanism.  I'd like to try it someday,
>> when I know a lot more about Pg.  My current project has an ever-growing
>> number of cron jobs (up to 6 now) and was just thinking about various
ways to
>> tidy it up.
>
>If you like to avoid the aid of your OS maybe Perl is your friend. There
>is a library Schedule::Cron which does the same as the crontab. I guess
>portability is given if you have your scheduler on the application level.


You might also be able to use pl/tcl's after function to do the same thing.

len morgan


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] maximum number of rows in table - what about oid limits?
Next
From: Alex Pilosov
Date:
Subject: Re: [HACKERS] something smells bad