Re: Can i write a time-trigger?

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: Shruthi A <shruthi(dot)iisc(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can i write a time-trigger?
Date: 2009-11-16 14:55:18
Message-ID: 4B0167D6.1070900@radev.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Shruthi A написа:
> Hello,
>
> Is it possible in postgres to write a trigger that is fired at a certain
> pre-defined time? ie I want to write a trigger that checks if the current
> time is one of a certain list of dates, and if yes, it should be executed.
> (I want it to execute only once on a matching date.)
>
> I'm using EnterpriseDB Postgres Plus 8.3

Take a look at pgAgent (http://www.pgadmin.org/docs/1.10/pgagent.html).

--
Milen A. Radev

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2009-11-16 17:10:40 Failed to restore/recreate database
Previous Message Jaume Sabater 2009-11-16 14:17:47 Re: Can i write a time-trigger?