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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
