Re: "trigger"ing a procedure every X minutes

From: "Len Morgan" <len-morgan(at)crcom(dot)net>
To: <Herbert(dot)Liechti(at)thinx(dot)ch>, "Fran Fabrizio" <ffabrizio(at)Exchange(dot)WebMD(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: "trigger"ing a procedure every X minutes
Date: 2001-06-06 23:19:24
Message-ID: 00f001c0eedf$20babac0$0908a8c0@H233.bstx.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2001-06-06 23:27:50 Re: [HACKERS] something smells bad
Previous Message Stephan Szabo 2001-06-06 23:16:43 Re: using create constraint trigger