[GENERAL] How can I run an external program from a stored procedure?

2010-06-04 Thread Rob Richardson
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

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

2010-06-04 Thread Tom Lane
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

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

2010-06-04 Thread Steve Atkins
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,