BUG: 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

[mww@…]

CC'ing unixODBC maintainer; Simon, how about adding

--includedir=$[prefix}/include/${name}

to configure.args in unixODBC?

[pguyot@…]

postgresql8 is deprecated. Please use postgresql81 instead.

[david.m.cooke@…]

This problem still occurs in postgresql81 and postgresql82 -- exact same error and same solution (uninstall unixODBC first).

[nerdrew@…]

I'm having this same problem with postgesql83 as well.

[jmr@…]

Assigning to maintainer.

[ryandesign@…]

Chris Waterson also reported this problem on macports-users.

[mcalhoun@…]

Duplicate of #14465.

[mcalhoun@…]

Attached is proposed fix to allow postgresql83 to be installed with unixODBC already installed.