Re: "trigger"ing a procedure every X minutes

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: "trigger"ing a procedure every X minutes
Дата
Msg-id m3ofs1v7yl.fsf@belphigor.mcnaught.org
обсуждение исходный текст
Ответ на "trigger"ing a procedure every X minutes  (Fran Fabrizio <ffabrizio@Exchange.WebMD.net>)
Список pgsql-general
Fran Fabrizio <ffabrizio@Exchange.WebMD.net> writes:

> Is the preferred method of calling a procedure every X minutes to have a
> cronjob installed external to the database, or is there something I can
> do internally to achieve the same effect (and would be portable along
> with the database when/if I move it to a different machine)?

I'm pretty sure there is no internal mechanism for scheduled
procedures.  I think the cronjob is your best bet.

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan

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

Предыдущее
От: Fran Fabrizio
Дата:
Сообщение: "trigger"ing a procedure every X minutes
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: [SQL] maximum number of rows in table - what about oid limits?