Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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