Re: Timed Triggers?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Timed Triggers?
Дата
Msg-id 7683.971130813@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Timed Triggers?  (Rod Taylor <rod.taylor@inquent.com>)
Список pgsql-hackers
Rod Taylor <rod.taylor@inquent.com> writes:
> With the number of cron jobs that run a perl script which runs a simple
> SELECT function(); that does various nightly cleanup or maintenance
> (billing run) it would be much nicer to have an actual trigger run every
> 12 hours rather than be initiated by a cron job.

Er ... why?  Seems like what you're describing is implementing the guts
of cron in the postmaster.  I don't see a real good reason to re-invent
the wheel like that.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "VARGA, Peter"
Дата:
Сообщение:
Следующее
От: "Reimer, Fred"
Дата:
Сообщение: ld.so error when inserting with a plpgsql trigger function