From: | Jason Earl <jason(dot)earl(at)simplot(dot)com> |
---|---|
To: | Lev Lvovsky <lists1(at)sonous(dot)com> |
Cc: | Jason Earl <jason(dot)earl(at)simplot(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: triggers on date? |
Date: | 2002-07-03 07:59:56 |
Message-ID: | 87vg7x5jib.fsf@npa01zz001.simplot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
With cron you could make your script "grab clients" every minute. If
you need even smaller increments between checks then the thing to do
would be to write a long running program.
Jason
Lev Lvovsky <lists1(at)sonous(dot)com> writes:
> this is for a billing system, at this point it's a toss-up b/w the
> following:
>
> 1. a script grabs clients which need billing on a nightly basis
> 2. a script grabs clients which need billing for a particular time
> interval (every hour, ever two hours etc...).
>
> what methods are used for making this close to real-time - constant
> polling?
>
> thanks!
> -lev
>
> On 2 Jul 2002, Jason Earl wrote:
>
> >
> > If it only needs to be /fairly/ realtime, then you could use cron to
> > fire a script every minute. Otherwise you could write an external
> > long-running program that listens for notifies.
> >
> > Jason
> >
> > Lev Lvovsky <lists1(at)sonous(dot)com> writes:
> >
> > > is it possible to create a trigger when the system time has reached the
> > > date of a particular record? I know this is possible with an external
> > > script, but I'm not quite sure how to go about making it fairly
> > > real-time...
> > >
> > > thanks!
> > > -lev
> > >
> > >
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > > message can get through to the mailing list cleanly
> >
>
> --
> personal site :: www.sonous.com
> rave site :: raves.sonous.com
> I'm a DJ! site :: djkgb.sonous.com
>
>
> "...is the best show on television. Its cooler than the other side of the
> pillow." -Kevin King
From | Date | Subject | |
---|---|---|---|
Next Message | frbn | 2002-07-03 08:16:38 | Re: Name of encodings: in which system catalog? |
Previous Message | Martijn van Oosterhout | 2002-07-03 00:58:10 | Re: Bad records in table |