> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Lane Van Ingen > Sent: Monday, October 10, 2005 12:41 PM > To: [email protected] > 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
