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 (Paul Guyot)]

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.

[jmroot (Joshua Root)]

Assigning to maintainer.

[ryandesign (Ryan Carsten Schmidt)]

Chris Waterson also ​reported this problem on macports-users.

[MarcusCalhoun-Lopez (Marcus Calhoun-Lopez)]

Duplicate of #14465.

[MarcusCalhoun-Lopez (Marcus Calhoun-Lopez)]

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

[nerdrew@…]

Is the fix going to be incorporated any time soon?

[mww@…]

Commited the patch from mcalhoun; thanks! ​#40203

[(none)]

Milestone Port Bugs deleted