Re: Scheduling Events?

From: "David Durst" <ddurst(at)larubber(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Scheduling Events?
Date: 2003-01-24 21:19:26
Message-ID: 34244.10.1.86.1.1043443166.squirrel@www.la-rubber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

here is a possible NON-Cron solution that a friend of mine came up w/

1) Create a table w/ scheduled events and Account Ids attached to them.
2) Create a table w/ temporal event execution timestamps.
3) On journal entry check to see if there any schedule events for the Account
4) Check timestamp table for last execution
If Last execution is out of range
force execution
Else
continue as normal

This is passive but it should allow for data integrity w/ out the need of
a external system.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2003-01-24 22:36:27 Re: Getting multiple rows in plpgsql function
Previous Message David Durst 2003-01-24 19:39:07 Getting multiple rows in plpgsql function