Re: Is there anyway to...

louis gonzales <gonzales(at)linuxlouis(dot)net> schrieb:

> Hey Brian,
> Yeah I had considered this, using cron, I just feel like that is too dirty.

Why?

>
> Actually I didn't see Andreas' post, can someone forward that?

Sorry, i posted to the list, and i can see my mail.

>
> 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?

Take a look at http://pgfoundry.org/projects/pgjob/

> Am I making any sense with how I'm asking this? I could of course have
> cron do a scheduled task of checking/incrementing/decrementing and define
> triggers to occur when one of the cron delivered actions sets the
> appropriate trigger off, but are there other methods that are standard in
> the industry or are we stuck with this type of external influence?

I'm using PG on Linux-systems and use CRON for any tasks, without any
problems. I can't understand your dislike...

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°