Re: sleep?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Don Drake <dondrake(at)gmail(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, John DeSoi <desoi(at)pgedit(dot)com>, Guido Barosio <gbarosio(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: sleep?
Date: 2005-08-23 15:07:40
Message-ID: 430B3BBC.7010607@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

  • Re: sleep? at 2005-08-23 14:42:27 from Don Drake

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2005-08-23 16:00:12 RPM 8.0.3 for RH7.3, RH7.2 and AS2.1
Previous Message Don Drake 2005-08-23 14:42:27 Re: sleep?