Bug 34605 – PostgreSQL and unixODBC installs sqltypes.h into the same place

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Tibor Sipos 2003-11-28 00:50:55 UTC]

Both Postgresql and unixODBC installs file sqltypes.h into /usr/include, thus 
overwriting each other. I've installed Postgres after ODBC, so it caused every 
package depending on unixODBC to fail to compile.

Reproducible: Always
Steps to Reproduce:
1. emerge unixODBC
2. emerge postgresql
3. emerge php

Actual Results:  
Php will fail because it wants to use unixODBC's sqltypes.h, but now it is 
overwritten with Postgresql's one.


Postgresql installs sqltypes.h into /usr/include AND 
/usr/include/postgresql/pgsql. These are the same files, so maybe modifying 
postgres ebuild to NOT save sqltypes.h to /usr/include will solve the problem.

[Comment 1 Andrei Ivanov 2003-12-02 12:06:30 UTC]

I think this might be related to bug #34007

[Comment 2 Robin Johnson 2003-12-06 20:15:10 UTC]

I'm testing a patch I hacked up for postgresql.

[Comment 3 Robin Johnson 2003-12-06 20:16:24 UTC]

main part of the patch
...
-       make DESTDIR=${D} install-all-headers || die
+       make DESTDIR=${D} pkgincludedir=/usr/include/postgresql/pgsql install-all-headers || die
...
-
-       dodir /usr/include/postgresql/pgsql
-       cp ${D}/usr/include/*.h ${D}/usr/include/postgresql/pgsql
-

[Comment 4 Robin Johnson 2003-12-06 20:41:52 UTC]

here is the final change i've got:
@@ -105,6 +105,7 @@ src_compile() {
                --host=${CHOST} \
                --docdir=/usr/share/doc/${PF} \
                --libdir=/usr/lib \
+               --includedir=/usr/include/postgresql/pgsql \
                --enable-depend \
                --with-gnu-ld \
                --with-maxbackends=1024 \
...
-
-       dodir /usr/include/postgresql/pgsql
-       cp ${D}/usr/include/*.h ${D}/usr/include/postgresql/pgsql
-

postgresql people care to comment?

[Comment 5 Robin Johnson 2004-01-05 02:43:57 UTC]

no response from postgresql people, so i'm fixed this myself.

[Comment 6 Masatomo Nakano (RETIRED) 2004-01-05 21:06:43 UTC]

I missed this bug. The fix is good :)

[Comment 7 Masatomo Nakano (RETIRED) 2004-01-17 16:07:54 UTC]

I reopen this bug.
See bug 38539

[Comment 8 Masatomo Nakano (RETIRED) 2004-01-18 06:32:21 UTC]

I've checked the file.

PostgreSQL installs /usr/include/sql3types.h
unixODBC installs /usr/include/sqltypes.h

It doesn't seem to be conflict.

I might misunderstand something...

[Comment 9 Jakub Moc (RETIRED) 2005-07-12 16:02:53 UTC]

$ slocate sqltypes.h
/usr/include/sqltypes.h
/usr/include/postgresql/informix/esql/sqltypes.h

$ equery b /usr/include/sqltypes.h
[ Searching for file(s) /usr/include/sqltypes.h in *... ]
dev-db/unixODBC-2.2.6 (/usr/include/sqltypes.h)

$ equery b /usr/include/postgresql/informix/esql/sqltypes.h
[ Searching for file(s) /usr/include/postgresql/informix/esql/sqltypes.h in *... ]
dev-db/postgresql-8.0.1-r4 (/usr/include/postgresql/informix/esql/sqltypes.h)

This is fixed, closing a stale bug.