| From: | "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | How can I run an external program from a stored procedure? |
| Date: | 2010-06-04 15:03:52 |
| Message-ID: | 04A6DB42D2BA534FAC77B90562A6A03D013E285A@server.rad-con.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
<file:///t:/Sales/Images/Marketing%20Pictures/Logos/LOGOs%20from%2010th%
20Floor/RAD-CON%20Logo%20for%20Signature.jpg>
RAD-CON, Inc.
TECHNOLOGY: Innovative & Proven
Phone : +1.440.871.5720 ... ext 123
Fax: +1.440.871.2948
Website: www.RAD-CON.com <http://www.rad-con.com/>
E-mail: rob(dot)richardson(at)RAD-CON(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-06-04 15:09:25 | Re: How can I run an external program from a stored procedure? |
| Previous Message | Alban Hertroys | 2010-06-04 14:07:35 | Re: cannot assign non-composite value to a row variable |