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

Поиск
Список
Период
Сортировка
От Rob Richardson
Тема How can I run an external program from a stored procedure?
Дата
Msg-id 04A6DB42D2BA534FAC77B90562A6A03D013E285A@server.rad-con.local
обсуждение исходный текст
Ответы Re: How can I run an external program from a stored procedure?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How can I run an external program from a stored procedure?  (Steve Atkins <steve@blighty.com>)
Список pgsql-general
Дерево обсуждения
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?
 
Thanks very much!
 
RobR
 

Robert D. Richardson
Product Engineer Software

RAD-CON, Inc.
TECHNOLOGY: Innovative & Proven
Phone : +1.440.871.5720 ... ext 123
Fax:  +1.440.871.2948
Website:  www.RAD-CON.com
E-mail:  rob.richardson@RAD-CON.com

 
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: cannot assign non-composite value to a row variable
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How can I run an external program from a stored procedure?