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

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 explains what flags to pass to gcc in order to
> compile your code on those and other platforms.

Take a look at "Extension Building Infrastructure" on that page and
also at the contrib modules' Makefiles.  In most cases you can let
PostgreSQL figure out how to build your code.

http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html#XFUNC-C-PGXS

--
Michael Fuhr