Re: [GENERAL] C trigger using system(3) to execute a php script

2006-02-18 Thread David Rio Deiros
On Sat, Feb 18, 2006 at 12:34:23PM -0700, Michael Fuhr wrote: > On Sat, Feb 18, 2006 at 10:59:16AM -0800, David Rio Deiros wrote: > > 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.pos

Re: [GENERAL] C trigger using system(3) to execute a php script

2006-02-18 Thread Michael Fuhr
On Sat, Feb 18, 2006 at 10:59:16AM -0800, David Rio Deiros wrote: > 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 expla

Re: [GENERAL] C trigger using system(3) to execute a php script

2006-02-18 Thread David Rio Deiros
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

Re: [GENERAL] C trigger using system(3) to execute a php script

2006-02-16 Thread Joshua D. Drake
Douglas McNaught wrote: David Rio Deiros <[EMAIL PROTECTED]> writes: The code was already in php... plus I am including some other php files so I would have to parse that files from C if I write all in C. I basically didn't want to do extra work. There's a PL/PHP out there, but I don't know i

Re: [GENERAL] C trigger using system(3) to execute a php script

2006-02-16 Thread Douglas McNaught
David Rio Deiros <[EMAIL PROTECTED]> writes: > The code was already in php... plus I am including some other php > files so I would have to parse that files from C if I write all in C. I > basically didn't want to do extra work. There's a PL/PHP out there, but I don't know if it's sufficiently ad

Re: [GENERAL] C trigger using system(3) to execute a php script

2006-02-16 Thread David Rio Deiros
On Thu, Feb 16, 2006 at 02:24:06PM -0500, Douglas McNaught wrote: > David Rio Deiros <[EMAIL PROTECTED]> 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 a

Re: [GENERAL] C trigger using system(3) to execute a php script

2006-02-16 Thread Douglas McNaught
David Rio Deiros <[EMAIL PROTECTED]> 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 p