Re: [SQL] run application from trigger?

2004-04-17 Thread Richard Huxton
On Friday 16 April 2004 21:21, Yudie wrote:
> Hi guys,
> I would like to create a trigger that execute some applications,
> is there a way to create a plpgsql function that execute shell command or
> any other way to run an application?
> Thanks for your help.

Have a rummage for the procedural language pl/sh - I think that is what you 
need.
-- 
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [SQL] Update is very slow on a bigger table

2004-04-17 Thread Bruno Wolff III
On Fri, Apr 16, 2004 at 12:47:58 -0500,
  Yudie <[EMAIL PROTECTED]> wrote:
> Hi guys,
> I would like to create a trigger that execute some programs,
> is there a way to create a plpgsql function that execute shell command or
> any other way to run a program?
> Thanks for your help.

Only untrusted languages can be used to run external programs. perlu might
be something you can use.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]