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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to