Re: [trigger] is it possible to launch a shell script?

--- Grgory_Luguet <gregory(dot)luguet(at)evidian(dot)com> wrote:
> I heard about triggers, but I did not find any way
> to activate something
> else than an SQL procedure with Postgresql ; with
> Oracle I know that I can
> launch nearly whatever I want (including standalone
> sowtware) and I can
> easily write a shell script which would call the
> mysql & insert the data,
> BUT is it possible at all?

I've read that you can write your trigger procedures
in C. Maybe you can use C system call to call a shell
script. I haven't tried programming stored procedures
in C.

The following is the section of the manual regarding
triggers

http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/triggers.html

Hope that helps,
ludwig.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com