Re: [PORTS] error compiling odbc support for 6.5.1 under OpenBSD

Diana,

You mentioned in your post that you first installed the "Free iODBC driver
manager". I'm not sure where iODBC fits into the picture but this seems to
be the source of those include files in /usr/local/include. They have the
same names (iodbc.h isql.h isqlext.h) as those in the PostgreSQL work
directory src/interfaces/odbc. Move aside the files in /usr/local/include
and try again.

At this point, I can't get pgsql+odbc to build either, but for different
reasons. I get past where your build stopped, but it hangs when building
the shared library because of a multiply defined symbol (_v8_regerror).
I'm looking at this now.

Ciao
--Louis <louis(at)bertrandtech(dot)on(dot)ca>

This is where my build quits:
ld -x -Bshareable -Bforcearchive -o libpsqlodbc.so.0.25 info.o bind.o
columninf
o.o connection.o convert.o drvconn.o environ.o execute.o lobj.o misc.o
options.o
pgtypes.o psqlodbc.o qresult.o results.o socket.o parse.o statement.o
gpps.o tu
ple.o tuplelist.o dlg_specific.o -lcompat -lm -lreadline -ltermcap
-lcurses
/usr/lib/libcompat.a(regerror.o): Definition of symbol `_v8_regerror'
(multiply
defined)
/usr/lib/libcompat.a(regex.o): Definition of symbol `_v8_regerror'
(multiply def
ined)
gmake[2]: *** [libpsqlodbc.so.0.25] Error 1
gmake[2]: Leaving directory
`/home/louis/ports/postgresql/work/postgresql-6.5.1/
src/interfaces/odbc'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory
`/home/louis/ports/postgresql/work/postgresql-6.5.1/
src/interfaces'
gmake: *** [all] Error 2
*** Error code 2

Louis Bertrand http://www.bertrandtech.on.ca
Bertrand Technical Services, Bowmanville, ON, Canada

OpenBSD: Secure by default. http://www.openbsd.org/

On Tue, 27 Jul 1999, Eichert, Diana wrote:

>
> Okay
>
> Thanks to Louis Bertrand there is now a port of 6.5.1 to OpenBSD,
> however in his default configuration he did not configure in odbc support.
> Okay, I thought I would. I installed the "Free iODBC driver manager", then
> reran configure, then make...
>
> everything compiles fine, then voila
>
> gmake[2]: Entering directory
> `/usr/ports/databases/postgresql/work/postgresql-6.
> 5.1/src/interfaces/odbc'
> cc -I../../include -I../../backend -I/usr/local/include -O2 -pipe -I.
> -DHAVE_C
> ONFIG_H -fpic -DPIC -c info.c -o info.o
> In file included from /usr/local/include/sql.h:37,
> from /usr/local/include/isql.h:32,
> from isqlext.h:8,
> from info.c:30:
> /usr/local/include/sqltypes.h:58: warning: `SQL_API' redefined
> isql.h:24: warning: this is the location of the previous definition
> In file included from /usr/local/include/sql.h:37,
> from /usr/local/include/isql.h:32,
> from isqlext.h:8,
> from info.c:30:
> /usr/local/include/sqltypes.h:65: redefinition of `UCHAR'
> isql.h:7: `UCHAR' previously declared here
> /usr/local/include/sqltypes.h:69: redefinition of `UDWORD'
> isql.h:10: `UDWORD' previously declared here
> /usr/local/include/sqltypes.h:70: redefinition of `SDWORD'
> isql.h:8: `SDWORD' previously declared here
> /usr/local/include/sqltypes.h:71: redefinition of `UWORD'
> isql.h:11: `UWORD' previously declared here
> /usr/local/include/sqltypes.h:72: redefinition of `SWORD'
> isql.h:9: `SWORD' previously declared here
> /usr/local/include/sqltypes.h:75: redefinition of `SFLOAT'
> psqlodbc.h:25: `SFLOAT' previously declared here
> /usr/local/include/sqltypes.h:76: redefinition of `SDOUBLE'
> psqlodbc.h:26: `SDOUBLE' previously declared here
> /usr/local/include/sqltypes.h:94: redefinition of `PTR'
> isql.h:13: `PTR' previously declared here
> /usr/local/include/sqltypes.h:107: redefinition of `HENV'
> isql.h:15: `HENV' previously declared here
> /usr/local/include/sqltypes.h:108: redefinition of `HDBC'
> isql.h:16: `HDBC' previously declared here
> /usr/local/include/sqltypes.h:109: redefinition of `HSTMT'
> isql.h:17: `HSTMT' previously declared here
> /usr/local/include/sqltypes.h:122: redefinition of `HWND'
> iodbc.h:30: `HWND' previously declared here
> /usr/local/include/sqltypes.h:130: redefinition of `RETCODE'
> isql.h:19: `RETCODE' previously declared here
> In file included from info.c:30:
> isqlext.h:348: redefinition of `SQLCHAR'
> /usr/local/include/sqltypes.h:83: `SQLCHAR' previously declared here
> isqlext.h:349: redefinition of `SQLSMALLINT'
> /usr/local/include/sqltypes.h:85: `SQLSMALLINT' previously declared here
> isqlext.h:350: redefinition of `SQLUSMALLINT'
> /usr/local/include/sqltypes.h:86: `SQLUSMALLINT' previously declared here
> isqlext.h:351: redefinition of `SQLINTEGER'
> /usr/local/include/sqltypes.h:87: `SQLINTEGER' previously declared here
> isqlext.h:352: redefinition of `SQLUINTEGER'
> /usr/local/include/sqltypes.h:88: `SQLUINTEGER' previously declared here
> isqlext.h:356: redefinition of `SQLSCHAR'
> /usr/local/include/sqltypes.h:84: `SQLSCHAR' previously declared here
> isqlext.h:357: redefinition of `BOOKMARK'
> /usr/local/include/sqltypes.h:137: `BOOKMARK' previously declared here
> isqlext.h:379: redefinition of `struct tagDATE_STRUCT'
> isqlext.h:383: redefinition of `DATE_STRUCT'
> /usr/local/include/sqltypes.h:146: `DATE_STRUCT' previously declared here
> isqlext.h:385: redefinition of `struct tagTIME_STRUCT'
> isqlext.h:389: redefinition of `TIME_STRUCT'
> /usr/local/include/sqltypes.h:155: `TIME_STRUCT' previously declared here
> isqlext.h:391: redefinition of `struct tagTIMESTAMP_STRUCT'
> isqlext.h:399: redefinition of `TIMESTAMP_STRUCT'
> /usr/local/include/sqltypes.h:168: `TIMESTAMP_STRUCT' previously declared
> here
> gmake[2]: *** [info.o] Error 1
> gmake[2]: Leaving directory
> `/usr/ports/databases/postgresql/work/postgresql-6.5
> .1/src/interfaces/odbc'
> gmake[1]: *** [all] Error 2
> gmake[1]: Leaving directory
> `/usr/ports/databases/postgresql/work/postgresql-6.5
> .1/src/interfaces'
> gmake: *** [all] Error 2
> *** Error code 2
>
> Stop in /usr/ports/databases/postgresql.
> *** Error code 1
>
> Stop in /usr/ports/databases/postgresql.
> *** Error code 1
>
> Stop in /usr/ports/databases/postgresql.
>
>
>
>