Re: How can I run an external program from a stored procedure?

On Jun 4, 2010, at 8:03 AM, Rob Richardson wrote:

> Greetings!
>  
> I'm running PostgreSQL 8.4 on MS Windows Server 2003.
>  
> Assume I have a program named FlashLightAndSoundHorn.exe.  In my database, there is a table that is read by some other program.  Records in that table have a timestamp, so I can tell how long they've been waiting.  I want a stored procedure that checks to see if a record has been waiting too long, and if it does, then it will run FlashLightAndSoundHorn.exe.  How do I run that program from inside a stored procedure?

A better way to do it is to have an external program that polls the database (or waits to be notified from a database trigger using listen/notify) and have that program do anything that's needed.

Cheers,
  Steve