Run a unix or perl command in a trigger

From: Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)bull(dot)net>
To: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Run a unix or perl command in a trigger
Date: 2004-07-01 14:59:18
Message-ID: 40E426C5.830BB23B@bull.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Postgres users,

I wonder to know if it is possible to launch a Perl program or a unix
comand in a trigger function.
I have tried to do that in a C trigger developed with the SPI function.
But my examples does not work and i don't have any error messages in the
postgres logfile.
So, i ask you your opinion and an example of code if your trigger works.

Regards,
Thierry Missimilly

Attachment Content-Type Size
THIERRY.MISSIMILLY.vcf text/x-vcard 359 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Montgomery 2004-07-01 15:02:06 Re: Dump / restore for optimization?
Previous Message Tom Lane 2004-07-01 14:52:30 Re: Bug in function to_char() !!