Re: issue:pgsql trigger with script file - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: issue:pgsql trigger with script file
Date
Msg-id 162867790907280759o4aa7436bl6d5114744fb0539f@mail.gmail.com
Whole thread Raw
In response to issue:pgsql trigger with script file  (nandakumar@obsitech.com)
List pgsql-bugs
Hello,

this isn't bug,  please, mail to pg_general mailing list.

It's not commendable technique call some external services from
trigger. It's much better to store data to some special table and then
periodically read this table and call external services from some
daemon application. But if you need it, then you can use
http://plsh.projects.postgresql.org/

I don't know if there is some similar project on window, but it's not
hard to write custom function in C and wrap exec system call. On
windows you can use plperlu and call external app from it.

regards
Pavel Stehule


2009/7/28  <nandakumar@obsitech.com>:
>
> hi
> =C2=A0 I have installed pgsql in linux, can i run a linux script file (.s=
h) with
> in a trigger. if it is possible , pls send me the brief notes.
> also send me , in windows can i run the batch(.bat) file.
>
>
> Thanks & Regards
> NandaKumar.R
> OBSI Technologies Pvt Ltd.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4948: getting error while vacuuming the database
Next
From: fous velkej
Date:
Subject: Re: BUG #4948: getting error while vacuuming the database