| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Jon Smark <jon(dot)smark(at)yahoo(dot)com> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Alarm function in PL/pgSQL |
| Date: | 2011-07-18 23:56:15 |
| Message-ID: | 4E24C81F.4060305@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 19/07/2011 6:35 AM, Jon Smark wrote:
> Thanks for the prompt reply. Just to clarify: you are saying that the
> function that is called with a given periodicity must be so from
> *outside* PG, ie, from the client application, right? I mean, there is
> no way strictly internal to PG to have a function be called every
> given number of seconds? Cheers, Jon
That's right. PostgreSQL has no built in scheduler feature.
PgAgent is designed to cover that need, so you should probably start there.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2011-07-19 00:34:21 | Re: How to sum monetary variables |
| Previous Message | Craig Ringer | 2011-07-18 23:54:25 | Re: How to sum monetary variables |