Hi there,
I just wanted to let you know that I finally made the trigger work using
an external php script. Actually it always worked, the problem is that
I was trying the trigger in one machine and testing the results in other.
I know, very lame.
Some people suggested plphp, I tried it but I had issues trying to compile
it. But the project looks promising anyway.
Also, I took me a while to figure out how to compile my trigger on
FreeBSD and MacOSX/Darwin. Finally I found this in the documentation:
http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html
which perfectly explains what flags to pass to gcc in order to
compile your code on those and other platforms.
I didn't find any link or reference to that document in the trigger
section. Do you think it would be a good idea to do that?
Thanks,
David
> 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.
