Обсуждение: 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
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
On Thu, 27 Jul 2000, julian cowans wrote: > 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 I guess a cron entry that runs psql to do a SELECT myfunction(), or some other commands, might work. -- - Robert