Re: "trigger"ing a procedure every X minutes

Поиск
Список
Период
Сортировка
От Len Morgan
Тема Re: "trigger"ing a procedure every X minutes
Дата
Msg-id 00f001c0eedf$20babac0$0908a8c0@H233.bstx.cc
обсуждение исходный текст
Ответ на "trigger"ing a procedure every X minutes  (Fran Fabrizio <ffabrizio@Exchange.WebMD.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] maximum number of rows in table - what about oid limits?
Следующее
От: Alex Pilosov
Дата:
Сообщение: Re: [HACKERS] something smells bad