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

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.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

Thanks Michael. I am going to rewrite my Makefile using PGXS.