Thank, for the fast response
>>In 7.1.3 triggers worked fine. With 7.3.2 triggers work in most cases
>>but in some cases execution fails at fork or exec.
>
> Fails how? What's the error code exactly?
fork: errno 2 /* No such file or directory */
exec: errno 11 /* Try again */
>
> The notion of running external programs from a trigger strikes me as a
> really bad idea in any case. (What happens if the transaction gets
> rolled back later? You won't be able to undo whatever the external
> program did.)
That's true, and we are aware of this problem. But it is still better to
have the database to do this than a web server.
Would you prefere to use a normal function?
Thanks in advance
Stefan
> But I don't know any reason why it would work less well
> now than in 7.1.
>
> regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
--
-----------------------------
Dr. Stefan Holzheu
Tel.: 0921/55-5720
Fax.: 0921/55-5799
BITOeK Wiss. Sekretariat
Universitaet Bayreuth
D-95440 Bayreuth
-----------------------------
