Thread: issue:pgsql trigger with script file

issue:pgsql trigger with script file

From
nandakumar@obsitech.com
Date:
<span style=3D"font-family:Verdana; color:#000000; font-size:10=
pt;">hi   I have installed pgsql in linux, can i run a linux s=
cript file (.sh) with in a trigger. if it is possible , pls send me the bri=
ef notes.also send me , in windows can i run the batch(.bat) file.<=
br> Thanks & Regards  NandaKumar.R  OBSI Technologies Pvt L=
td.

Re: issue:pgsql trigger with script file

From
Pavel Stehule
Date:
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.