Re: Regular function - Mailing list pgsql-general

From John R Pierce
Subject Re: Regular function
Date
Msg-id 5155D9BC.6080603@hogranch.com
Whole thread Raw
In response to Regular function  (Yuriy Rusinov <yrusinov@gmail.com>)
Responses Re: Regular function
Re: Regular function
List pgsql-general
On 3/29/2013 10:54 AM, Yuriy Rusinov wrote:
> I have to write pl/pgsql function that has to be triggered not
> before/after insert, but in definite time. Does postgresql allows to
> do this ?


there is no 'cron' built into postgresql.   you could write your
function, then have an external cron job invoke it, like: psql -c
"select yourfunction()"


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Yuriy Rusinov
Date:
Subject: Regular function
Next
From: John R Pierce
Date:
Subject: Re: Regular function