compile error when installing postgresql8 after unixODBC

[erickt@…]

Hello,

I ran into a problem compiling postgresql 8 after I installed unixODBC. Since unixODBC also defines a header sqltypes.h, postgresql is picking up this file and erroring out:

gcc -no-cpp-precomp -I/opt/local/include -Wall -Wmissing-prototypes -Wpointer-arith -Wendif- labels -fno-strict-aliasing -I../../../../src/interfaces/ecpg/include -I../../../../src/interfaces/libpq -I../ ../../../src/include/utils -I../../../../src/include -I/opt/local/include -I/opt/local/include -c -o informix.o informix.c informix.c: In function `deccall3': informix.c:67: error: `CDECIMALTYPE' undeclared (first use in this function) informix.c:67: error: (Each undeclared identifier is reported only once informix.c:67: error: for each function it appears in.)

I can manually get this to compile if I disable unixODBC, but that doesn't seem to be an optimal solution. Or, if I move the "-I/opt/local/include" to the end of that command, it compiles fine. Is there any chance to have the unixODBC headers moved into their own namespace out of /opt/local/include? Or does someone else know a better solution?

Thanks,

-e