Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 62C6C9FB2AF for ; Thu, 2 Nov 2006 15:01:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 41742-05 for ; Thu, 2 Nov 2006 19:01:29 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id C5D6A9FB2A7 for ; Thu, 2 Nov 2006 15:01:28 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so183886ugf for ; Thu, 02 Nov 2006 11:01:27 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=WmxV2Vywakqe3YwrzKvYHe7EaVxaruHNfOp8yGOFRkuB6aP+0qN3fwgXTBtKE4KpKoEY+RgGfZ+rs1WsK+jJUK0gv53z3o2ZZxHsSC7xpGV88K3WQsYy88Y7oAypKtQwhtL2YZSwWQzVbWfrEzy8ZUYuG7nkaVIjPgR9VMewGmI= Received: by 10.78.128.15 with SMTP id a15mr1180901hud.1162494086948; Thu, 02 Nov 2006 11:01:26 -0800 (PST) Received: by 10.78.141.5 with HTTP; Thu, 2 Nov 2006 11:01:26 -0800 (PST) Message-ID: <725602300611021101q27dff609j786c6edd6177de9e@mail.gmail.com> Date: Thu, 2 Nov 2006 19:01:26 +0000 From: "Ian Harding" To: "louis gonzales" Subject: Re: Is there anyway to... Cc: brian , pgsql-general@postgresql.org In-Reply-To: <454A3EB6.8080806@linuxlouis.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20061102171624.GE21312@localhost> <454A357E.6010409@linuxlouis.net> <454A394C.7020102@zijn-digital.com> <454A3EB6.8080806@linuxlouis.net> X-Google-Sender-Auth: 8220716bcf98d9be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/181 X-Sequence-Number: 103277 On 11/2/06, louis gonzales 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