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

Hi Diana,

Just showing lifesigns... I had a quick look today and it's probably
something to do with the configure or configure.in scripts in
src/interfaces/odbc but I really haven't had the time to really dig into
it (I'm pushing a deadline).

Ciao
 --Louis  <louis@bertrandtech.on.ca>

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

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

On Wed, 28 Jul 1999, Eichert, Diana wrote:

> Louis
>
>     I had loaded the iODBC driver manager because I installed ODBC
> support for Perl, as soon as I moved those header files out of the way I was
> able to duplicate your error messages.
>
>     Anyone have ideas?
>
> diana
>
> -----Original Message-----
> From: Louis Bertrand [mailto:louis@bertrandtech.on.ca]
> Sent: Tuesday, July 27, 1999 8:32 PM
> To: Eichert, Diana
> Cc: 'pgsql-ports@postgresql.org'
> Subject: 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@bertrandtech.on.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.
> >
> >
> >
> >
>
>
>
>
>
>
>