Postgres Pro
Downloads
Home   >   mailing lists

Thread: Triggers - temporal

Triggers - temporal

From
"julian cowans"
Date:
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

RE: Triggers - temporal

From
"Sykora, Dale"
Date:
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

Re: Triggers - temporal

From
"Robert B. Easter"
Date:
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