From: Josh Berkus <josh@agliodbs.com>
To: Jimmie Fulton <JFulton@ehso.emory.edu>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: Functions performed on intervals
Date: Thu, 12 Jul 2001 12:10:46 -0700
Message-ID: <web-84978@davinci.ethosmedia.com> (raw)
In-Reply-To: <FB93404FB67ED311ABF9009027991188417EC5@www.ehso.emory.edu>
Jimmie,
> Thanks for your response,
You're welcome.
> What you are saying here is that I will indeed need an external timed
> event
> (cron) to update a field/history table of some fashion, correct?
> This is my
> main question.
Yes. Absolutely you will. Unless, of course, your users are already
forced to go though a manual month-end procedure, in which case it could
be tied to that.
This is actually really easy to set up:
1. Create a shell script that calls psql and a SQL script in 2;
2. Create a SQL script that calls all of the functions that you want to
run on a (daily/weekly/monthly) basis.
3. Create a cron item that calls the shell script (1.).
Handling errors etc. obviously adds a layer of complexity to the
scripting. I also have the functions write to a schedule_log table
showing what they've done.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, JFulton@ehso.emory.edu
Subject: Re: Functions performed on intervals
In-Reply-To: <web-84978@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox