David Rio Deiros <driodeiros@gmail.com> writes:
> 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.
Why would you do it that way? The queries/inserts won't be rolled
back if the transaction containing the trigger aborts (because they'd
be done in a separate session). Why not just do your queries from C
using the SPI interface?
-Doug