Hi there,
I have written a trigger in C for a postgresql engine (8.0.1) running
on a FreeBSD 5.4-RELEASE i386 machine.
I mainly used the example code from the documentation. The trigger
is working perfectly and it is triggered when I want to.
Then, at some point, I wanted to call an external php script from
the trigger to perform some sql statements against the database.
Before trying that I started writing a very simple php script
which basically created a file in /tmp. It worked.
Then, I wanted to run the full php script from the trigger. I tried
the script manually, form the shell, and it worked perfectly. Notice
that the script doesn't generate any stdin/stdout output. So I changed
the system(3) parameter to call my php script instead of the test one.
I tried it and it didn't work. The php script doesn't perform the
modifications it suppose to in the database.
The php script is about 150 lines long and performs like 5 or 6 sql
queries/inserts against the database.
Can anyone advice me with these?
Thanks in advance,
David