Trigger to call an external program

From: Alan Graham <alan(dot)graham(at)infonetsystems(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: Trigger to call an external program
Date: 2003-12-04 15:13:10
Message-ID: 1070550790.3133.8.camel@bart.graham.fdns.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm doing a low cost, low performance roll your own replication project,
between various offices around Australia. The replication is
asynchronous, and peer to peer. I've looked at the various replication
projects, and for one reason or another, they're too hard.

My design uses jabber as middleware, using python scripts to do the hard
work. However, it depends on triggers calling my python scripts to
work. I can't find a way to call an external script from a trigger.
I've searched the archives, and found a few other people asking the same
question, but no answers (apart from the odd sanctimonious "well you
shouldn't be doing that..." :-).

I thought I was onto a winner with pgplsh, but I can't get it to compile
with 7.3.4, although it compiled beautifully with 7.2.1.

Using python as a trigger language also seems to be a non-starter,
because the restricted python environment isn't yet working.

So... Is there an easy way to call a script from a trigger?

Thanks

Alan Graham

--
Alan Graham <alan(dot)graham(at)infonetsystems(dot)com(dot)au>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-12-04 15:19:49 Re: Index not used. WHY?
Previous Message Andrei Bintintan 2003-12-04 14:57:51 Index not used. WHY?