On Mon, Nov 16, 2009 at 2:42 PM, Shruthi A <shruthi.iisc@xxxxxxxxx> wrote: > 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 AFAIK, no, you cannot. But you can use a cron job that executes that trigger via psql, same way you would do in the command console. -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas" -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
