Date: Thu, 2 Nov 2006 20:09:06 +0100
From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-general@postgresql.org
Subject: Re: Is there anyway to...
Message-ID: <20061102190906.GA23069@KanotixBox>
References: <20061102171624.GE21312@localhost>
	<454A357E.6010409@linuxlouis.net>
	<454A394C.7020102@zijn-digital.com>
	<454A3EB6.8080806@linuxlouis.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <454A3EB6.8080806@linuxlouis.net>
User-Agent: mutt-ng 1.5.9i (Linux)

louis gonzales <gonzales@linuxlouis.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°