From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Lane Van Ingen <lvaningen(at)esncc(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Need A Suggestion |
Date: | 2005-10-10 20:22:39 |
Message-ID: | 20051010202239.GF16158@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Oct 10, 2005 at 03:40:43PM -0400, Lane Van Ingen wrote:
> 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.
You may be able to use the LISTEN/NOTIFY structure described below
instead of a trigger.
http://www.postgresql.org/docs/current/static/sql-notify.html
http://www.postgresql.org/docs/current/static/libpq-notify.html
http://blackhawk.supernews.net/listen.pl.txt
> 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?
>
> I have already consulted to other mailing lists for help, with no
> results. I am a Windows 2003 user, version 8.0.1
You might want to upgrade to 8.0.4 :)
Cheers,
David.
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-10-10 20:32:19 | Re: Need A Suggestion |
Previous Message | Andrew Dunstan | 2005-10-10 20:16:53 | Re: Need A Suggestion |