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 time

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

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

[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 stored