Stefan Holzheu <stefan(dot)holzheu(at)bitoek(dot)uni-bayreuth(dot)de> writes:
> Last friday we did an upgrade from postgres 7.1.3 to 7.3.2. In the
> database there are triggers written in C, which start external programs
> using the system calls fork+exec.
> 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?
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.) But I don't know any reason why it would work less well
now than in 7.1.
regards, tom lane