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.
-Don
On 8/22/05, Michael Fuhr <mike@xxxxxxxx> wrote:
On Mon, Aug 22, 2005 at 08:34:29AM -0500, Don Drake wrote:
> I agree that a basic function (non-CPU intensive sleep) like this should be
> built in.
It's being discussed in pgsql-hackers:
http://archives.postgresql.org/pgsql-hackers/2005-08/msg00633.php
Do you have any use cases in addition to what's already been
mentioned? Sleeping isn't really a database operation, so there
needs to be some justification for making it a standard function.
--
Michael Fuhr
--
Donald Drake
President
Drake Consulting
http://www.drakeconsult.com/
http://www.MailLaunder.com/
http://www.mobilemeridian.com/
312-560-1574
