Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

pgsqlodbc installation problem

Ganuchaud
Occasional Advisor

pgsqlodbc installation problem

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
3 REPLIES
A. Clay Stephenson
Acclaimed Contributor

Re: pgsqlodbc installation problem

strtoll() is not implemented on HP-UX but is not too difficult a function to write yourself.
If it ain't broke, I can fix that.
Ganuchaud
Occasional Advisor

Re: pgsqlodbc installation problem

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
Ganuchaud
Occasional Advisor

Re: pgsqlodbc installation problem

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

Alain