topic Re: pgsqlodbc installation problem in Operating System - HP-UX

pgsqlodbc installation problem

Ganuchaud — Tue, 20 Jun 2006 13:10:37 GMT

Hello,

we successfully install postgresql 8.1.4 on hp-ux 11i V1 but failed to install pgsqlodbc 08.02.0002 (recommended odbc driver for postgresql) with unixodbc 2.2.11.
We are using gcc 4.1.1 and gmake 3.80, gmake fail s with the following error:

gcc -DHAVE_CONFIG_H -I. -I. -I. -I/disk1/pgsql-with-rl/include -g -O2 -MT convert.lo -MD -MP -MF .deps/convert.Tpo -c convert.c -fPIC -DPIC -o .libs/convert.oconvert.c:188:2: error: #error cant handle ODBCINT64
convert.c: In function 'ResolveOneParam':
convert.c:3236: error: 'FORMATI64' undeclared (first use in this function)
convert.c:3236: error: (Each undeclared identifier is reported only once
convert.c:3236: error: for each function it appears in.)
convert.c:3241: error: 'FORMATI64U' undeclared (first use in this function)
gmake[1]: *** [convert.lo] Error 1
gmake[1]: Leaving directory `/tmp/postgresql-8.1.4/src/interfaces/odbc'
gmake: *** [all] Error 2

Attached is the config.log, an error about strtoll is in it.

Thanks for help
Alain

Re: pgsqlodbc installation problem

A. Clay Stephenson — Tue, 20 Jun 2006 13:49:39 GMT

strtoll() is not implemented on HP-UX but is not too difficult a function to write yourself.

Re: pgsqlodbc installation problem

Ganuchaud — Wed, 21 Jun 2006 02:27:32 GMT

Thanks for this help,

I'm not a C guru, could you help more?
What do you mean? or Do you have an example?

Thanks,
Alain

Re: pgsqlodbc installation problem

Ganuchaud — Fri, 23 Jun 2006 02:46:58 GMT

Psqlodbc team posted a patch for solving this problem. I attached it for anyone who needs it.

Alain