On Sat, Mar 30, 2013 at 3:13 AM, John R Pierce <pie...@hogranch.com> wrote:
> 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()" > Note also that if you are planning some development with the coming release 9.3, you could also achieve that inside the server by using a custom bgworker. -- Michael