"Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com> writes:
> 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?
If you write in plperlu or plpythonu then you can use those languages'
ordinary ability to run a subprocess.
regards, tom lane