RE: Triggers - temporal - Mailing list pgsql-novice

From Sykora, Dale
Subject RE: Triggers - temporal
Date
Msg-id 415DD0BB9FAFD011B6E700805FBEB68E05778303@exchou-ca0801bk.im.hou.compaq.com
Whole thread Raw
In response to Triggers - temporal  ("julian cowans" <jcowans@hotmail.com>)
List 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.sykora@compaq.com

-----Original Message-----
From: julian cowans [mailto:jcowans@hotmail.com]
Sent: Thursday, July 27, 2000 11:54 AM
To: pgsql-novice@postgresql.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

pgsql-novice by date:

Previous
From: "julian cowans"
Date:
Subject: Triggers - temporal
Next
From: "Robert B. Easter"
Date:
Subject: Re: Triggers - temporal