From: Ian Harding <iharding@destinydata.com>
To: louis gonzales <gonzales@linuxlouis.net>
Cc: brian <brian@zijn-digital.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Is there anyway to...
Date: Thu, 2 Nov 2006 19:01:26 +0000
Message-ID: <725602300611021101q27dff609j786c6edd6177de9e@mail.gmail.com> (raw)
In-Reply-To: <454A3EB6.8080806@linuxlouis.net>
References: <20061102171624.GE21312@localhost>
<454A357E.6010409@linuxlouis.net>
<454A394C.7020102@zijn-digital.com>
<454A3EB6.8080806@linuxlouis.net>
On 11/2/06, louis gonzales <gonzales@linuxlouis.net> wrote:
> Hey Brian,
> Yeah I had considered this, using cron, I just feel like that is too dirty.
>
> Actually I didn't see Andreas' post, can someone forward that?
>
> I'm running this application on Solaris 9. Ultimately what I want to
> know is, is there something that is internal to postgresql that can be
> used that doesn't need external action, to make it do some task?
>
Your original scenario had an external action, instructor login. The
daily increment is the days since account creation.
Since we don't have triggers based on login, you maybe could tickle a
function from your front-end that would simply look for students with
account age > 30 and not paid whenever the instructor logs in.
Short of that, an OS based scheduler (AT, cron, etc.) is your only
choice I can think of
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: iharding@destinydata.com, gonzales@linuxlouis.net, brian@zijn-digital.com, pgsql-general@postgresql.org
Subject: Re: Is there anyway to...
In-Reply-To: <725602300611021101q27dff609j786c6edd6177de9e@mail.gmail.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