This is a discussion on Re: Need A Suggestion within the pgsql Hackers forums, part of the PostgreSQL category; --> > -----Original Message----- > From: pgsql-hackers-owner@postgresql.org [mailto gsql-hackers- > owner@postgresql.org ] On Behalf Of Lane Van Ingen > Sent: ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > -----Original Message----- > From: pgsql-hackers-owner@postgresql.org [mailto > owner@postgresql.org] On Behalf Of Lane Van Ingen > Sent: Monday, October 10, 2005 12:41 PM > To: pgsql-hackers@postgresql.org > Subject: [HACKERS] Need A Suggestion > > I am working on the development of a military application which uses > PostgreSQL trigger functions. I cannot (unfortunately) tell you specify > use, > being as it is classified. > > What I need the ability to occasionally call (execute) a .exe program > object > outside of the database from within the function (either during or at the > end of the function would be acceptable), giving an explicit path and > command line parameters. It is understood that in doing such the call will > need to be brief in order to avoid slowing up PostgreSQL in any way. Can > anybody make a suggestion as to how to do that, or inform me if there is a > way to do thisa lready? This is vague. Perhaps what you want to accomplish is best accomplished by creation of a function from the source code. You could also create a generic function that takes a string parameter and then does a system call based upon that string. If you need asynchronous operation look at exec.c > I have already consulted to other mailing lists for help, with no results. > I > am a Windows 2003 user, version 8.0.1 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |