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