"Rob Richardson" <Rob.Richardson@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
