Re: sleep?

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