X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8B8EED6FB1 for ; Tue, 23 Aug 2005 12:07:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10562-10 for ; Tue, 23 Aug 2005 15:06:42 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 20CACD6F89 for ; Tue, 23 Aug 2005 12:06:41 -0300 (ADT) Received: from [192.168.1.100] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id j7NF4Yfo005708; Tue, 23 Aug 2005 08:04:34 -0700 Message-ID: <430B3BBC.7010607@commandprompt.com> Date: Tue, 23 Aug 2005 08:07:40 -0700 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050727) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Don Drake Cc: Michael Fuhr , John DeSoi , Guido Barosio , pgsql-admin@postgresql.org Subject: Re: sleep? References: <6c21003b050821122278e3d7d5@mail.gmail.com> <6c21003b05082206341411de2d@mail.gmail.com> <20050822140133.GA60020@winnie.fuhr.org> <6c21003b05082307427ea67279@mail.gmail.com> In-Reply-To: <6c21003b05082307427ea67279@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Tue, 23 Aug 2005 08:04:35 -0700 (PDT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.023 required=5 tests=[AWL=0.023] X-Spam-Level: X-Archive-Number: 200508/283 X-Sequence-Number: 18602 Don Drake wrote: > Sorry for the delay in replying. > > The use-case that I have is the following. I'm writing a job-control > tracking sub-system that will store when jobs are started, finished, > failed, etc. I would like to have the ability to have a process that > is requesting to start, to actually wait a specified period time > before starting. It could wait for another job to finish. I'm > writing this in plpgsql since I'm storing status in the db. I would write a userspace daemon that ran outside of PostgreSQL to call your procedures as you need them to run. Sincerely, Joshua D. Drake