Обсуждение: issue:pgsql trigger with script file

Поиск
Список
Период
Сортировка

issue:pgsql trigger with script file

От
nandakumar@obsitech.com
Дата:
<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

От
Pavel Stehule
Дата:
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.