| From: | "Sykora, Dale" <Dale(dot)Sykora(at)compaq(dot)com> |
|---|---|
| To: | "'julian cowans'" <jcowans(at)hotmail(dot)com>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | RE: Triggers - temporal |
| Date: | 2000-07-27 17:13:21 |
| Message-ID: | 415DD0BB9FAFD011B6E700805FBEB68E05778303@exchou-ca0801bk.im.hou.compaq.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Julian,
Perhaps you could create a table with a timestamp field and 1 record. Then
have a (perl/python/etc...) script running under a cron job update the
record. Setup your trigger to run when the record is updated.
dale(dot)sykora(at)compaq(dot)com
-----Original Message-----
From: julian cowans [mailto:jcowans(at)hotmail(dot)com]
Sent: Thursday, July 27, 2000 11:54 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Triggers - temporal
Is it possible to trigger certain events at pre-defined times? I am using
version 6.5.2, which suggests triggers can only be kicked off with a
<INSERT|UPDATE|DELETE> sql command.
Thanks, Julian
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Caskey | 2000-07-27 17:24:55 | Re: 4 billion record limit? |
| Previous Message | Phillip J. Allen | 2000-07-27 17:05:38 | Islands in Polygons |