| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Regular function |
| Date: | 2013-03-30 01:50:27 |
| Message-ID: | CAB7nPqR2jm9FrebF6f92pS_AZe-_1QoLnF4+aArJXiiGkUXaJA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Mar 30, 2013 at 3:13 AM, John R Pierce <pierce(at)hogranch(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Modulok | 2013-03-30 02:38:32 | data modeling genes and alleles... help! |
| Previous Message | Gavan Schneider | 2013-03-30 01:04:21 | Re: Money casting too liberal? |