Re: Need A Suggestion

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-
> 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