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