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.