Re: Update is very slow on a bigger table

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Yudie <yudie(at)axiontech(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Update is very slow on a bigger table
Date: 2004-04-19 15:33:35
Message-ID: Pine.LNX.4.33.0404190933180.16551-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, 17 Apr 2004, Bruno Wolff III wrote:

> On Fri, Apr 16, 2004 at 12:47:58 -0500,
> Yudie <yudie(at)axiontech(dot)com> 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.

Also, take a look at plsh if all you need is to run shell functions:

http://developer.postgresql.org/~petere/pgplsh/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message CoL 2004-04-19 15:47:07 Re: Concatenate results of a single column query
Previous Message Christoph Haller 2004-04-19 15:15:14 Re: Concatenate results of a single column query