Re: Running Command Line From Trigger?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Yudie Pg <yudiepg(at)gmail(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Running Command Line From Trigger?
Date: 2006-04-07 15:51:51
Message-ID: 1144425111.32266.133.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2006-04-07 at 10:42, Yudie Pg wrote:
>
>
> I'm running postgresql 7.4.1. is it can't really be used for trigger
> function?
>
> http://www.postgresql.org/docs/7.4/static/plperl-missing.html
>

Two points:

1: Upgrade to 7.4.12 (or whatever the latest version is) immediately.
There are known data loss bugs in 7.4.1, and usually, the closer you are
to 7.4.0, the more likely those kinds of bugs are to show up. I.e. a
data loss bug discovered in 7.4.11 and fixed in 7.4.12 is probably
REALLY rare, but one found in 7.4.0 and fixed in 7.4.2 is much more
likely to be a common occurrence, since those are found early on.

2: Try using plphp. It can be used for triggers. So can pltcl if
you'd rather use that.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-04-07 15:52:53 Re: Running Command Line From Trigger?
Previous Message Yudie Pg 2006-04-07 15:42:42 Re: Running Command Line From Trigger?