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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general