triggers on date?
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
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@sonous.com> writes:
Show quoted text
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@postgresql.org so that your
message can get through to the mailing list cleanly
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@sonous.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@postgresql.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
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@sonous.com> writes:
Show quoted text
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!
-levOn 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@sonous.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@postgresql.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