Skip site navigation (1) Skip section navigation (2)

Re: issue:pgsql trigger with script file

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: nandakumar(at)obsitech(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: issue:pgsql trigger with script file
Date: 2009-07-28 14:59:43
Message-ID: 162867790907280759o4aa7436bl6d5114744fb0539f@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)obsitech(dot)com>:
>
> hi
>   I have installed pgsql in linux, can i run a linux script file (.sh) 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.

In response to

pgsql-bugs by date

Next:From: fous velkejDate: 2009-07-28 17:04:53
Subject: Re: BUG #4948: getting error while vacuuming the database
Previous:From: Tom LaneDate: 2009-07-28 14:01:37
Subject: Re: BUG #4948: getting error while vacuuming the database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group