Re: issue:pgsql trigger with script file

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: issue:pgsql trigger with script file
Дата
Msg-id 162867790907280759o4aa7436bl6d5114744fb0539f@mail.gmail.com
обсуждение исходный текст
Ответ на issue:pgsql trigger with script file  (nandakumar@obsitech.com)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4948: getting error while vacuuming the database
Следующее
От: fous velkej
Дата:
Сообщение: Re: BUG #4948: getting error while vacuuming the database