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