Thread: BUG #17114: postgresql odbc driver compilation

The following bug has been logged on the website:

Bug reference:      17114
Logged by:          Dmitry Muzalkov
Email address:      supermultik@yandex.ru
PostgreSQL version: 12.7
Operating system:   solaris 11.4
Description:

Hello. 
I tried to compile postgresql odbc driver on solaris 11.4 OS 
During the compilation I got the error:

libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/usr/include/odbc
-I/opt/csw/include -I/opt/csw/include/postgresql/internal -DUNICODE_SUPPORT
-g -O2 -Wall -MT psqlodbcw_la-mylog.lo -MD -MP -MF
.deps/psqlodbcw_la-mylog.Tpo -c mylog.c  -fPIC -DPIC -o
.libs/psqlodbcw_la-mylog.o
mylog.c: In function 'generate_filename':
mylog.c:85:37: warning: format '%u' expects argument of type 'unsigned int',
but argument 4 has type 'pid_t {aka long int}' [-Wformat=]
  snprintfcat(filename, filenamelen, "%u%s", pid, ".log");
                                     ^
mv -f .deps/psqlodbcw_la-mylog.Tpo .deps/psqlodbcw_la-mylog.Plo
/bin/sh ./libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.
-I/usr/include/odbc -I/opt/csw/include
-I/opt/csw/include/postgresql/internal -DUNICODE_SUPPORT -g -O2 -Wall -MT
psqlodbcw_la-odbcapi30w.lo -MD -MP -MF .deps/psqlodbcw_la-odbcapi30w.Tpo -c
-o psqlodbcw_la-odbcapi30w.lo `test -f 'odbcapi30w.c' || echo
'./'`odbcapi30w.c
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/usr/include/odbc
-I/opt/csw/include -I/opt/csw/include/postgresql/internal -DUNICODE_SUPPORT
-g -O2 -Wall -MT psqlodbcw_la-odbcapi30w.lo -MD -MP -MF
.deps/psqlodbcw_la-odbcapi30w.Tpo -c odbcapi30w.c  -fPIC -DPIC -o
.libs/psqlodbcw_la-odbcapi30w.o
mv -f .deps/psqlodbcw_la-odbcapi30w.Tpo .deps/psqlodbcw_la-odbcapi30w.Plo
/bin/sh ./libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.
-I/usr/include/odbc -I/opt/csw/include
-I/opt/csw/include/postgresql/internal -DUNICODE_SUPPORT -g -O2 -Wall -MT
psqlodbcw_la-odbcapiw.lo -MD -MP -MF .deps/psqlodbcw_la-odbcapiw.Tpo -c -o
psqlodbcw_la-odbcapiw.lo `test -f 'odbcapiw.c' || echo './'`odbcapiw.c
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/usr/include/odbc
-I/opt/csw/include -I/opt/csw/include/postgresql/internal -DUNICODE_SUPPORT
-g -O2 -Wall -MT psqlodbcw_la-odbcapiw.lo -MD -MP -MF
.deps/psqlodbcw_la-odbcapiw.Tpo -c odbcapiw.c  -fPIC -DPIC -o
.libs/psqlodbcw_la-odbcapiw.o
mv -f .deps/psqlodbcw_la-odbcapiw.Tpo .deps/psqlodbcw_la-odbcapiw.Plo
/bin/sh ./libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.
-I/usr/include/odbc -I/opt/csw/include
-I/opt/csw/include/postgresql/internal -DUNICODE_SUPPORT -g -O2 -Wall -MT
psqlodbcw_la-win_unicode.lo -MD -MP -MF .deps/psqlodbcw_la-win_unicode.Tpo
-c -o psqlodbcw_la-win_unicode.lo `test -f 'win_unicode.c' || echo
'./'`win_unicode.c
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/usr/include/odbc
-I/opt/csw/include -I/opt/csw/include/postgresql/internal -DUNICODE_SUPPORT
-g -O2 -Wall -MT psqlodbcw_la-win_unicode.lo -MD -MP -MF
.deps/psqlodbcw_la-win_unicode.Tpo -c win_unicode.c  -fPIC -DPIC -o
.libs/psqlodbcw_la-win_unicode.o
mv -f .deps/psqlodbcw_la-win_unicode.Tpo
.deps/psqlodbcw_la-win_unicode.Plo
/bin/sh ./libtool  --tag=CC    --mode=link gcc -DUNICODE_SUPPORT  -g -O2
-Wall -module -no-undefined -avoid-version -export-symbols-regex '^SQL'
-L/usr/lib -L/opt/csw/lib -o psqlodbcw.la -rpath /usr/local/lib
psqlodbcw_la-info.lo psqlodbcw_la-bind.lo  psqlodbcw_la-columninfo.lo
psqlodbcw_la-connection.lo  psqlodbcw_la-convert.lo psqlodbcw_la-drvconn.lo
psqlodbcw_la-environ.lo psqlodbcw_la-execute.lo  psqlodbcw_la-lobj.lo
psqlodbcw_la-misc.lo  psqlodbcw_la-options.lo psqlodbcw_la-pgtypes.lo
psqlodbcw_la-psqlodbc.lo psqlodbcw_la-qresult.lo  psqlodbcw_la-results.lo
psqlodbcw_la-parse.lo  psqlodbcw_la-statement.lo psqlodbcw_la-tuple.lo
psqlodbcw_la-dlg_specific.lo psqlodbcw_la-multibyte.lo
psqlodbcw_la-odbcapi.lo psqlodbcw_la-descriptor.lo
psqlodbcw_la-odbcapi30.lo psqlodbcw_la-pgapi30.lo  psqlodbcw_la-mylog.lo
psqlodbcw_la-odbcapi30w.lo  psqlodbcw_la-odbcapiw.lo
psqlodbcw_la-win_unicode.lo  -lpq -lpthread -lodbcinst
libtool: link: /usr/bin/nm -p  .libs/psqlodbcw_la-info.o
.libs/psqlodbcw_la-bind.o .libs/psqlodbcw_la-columninfo.o
.libs/psqlodbcw_la-connection.o .libs/psqlodbcw_la-convert.o
.libs/psqlodbcw_la-drvconn.o .libs/psqlodbcw_la-environ.o
.libs/psqlodbcw_la-execute.o .libs/psqlodbcw_la-lobj.o
.libs/psqlodbcw_la-misc.o .libs/psqlodbcw_la-options.o
.libs/psqlodbcw_la-pgtypes.o .libs/psqlodbcw_la-psqlodbc.o
.libs/psqlodbcw_la-qresult.o .libs/psqlodbcw_la-results.o
.libs/psqlodbcw_la-parse.o .libs/psqlodbcw_la-statement.o
.libs/psqlodbcw_la-tuple.o .libs/psqlodbcw_la-dlg_specific.o
.libs/psqlodbcw_la-multibyte.o .libs/psqlodbcw_la-odbcapi.o
.libs/psqlodbcw_la-descriptor.o .libs/psqlodbcw_la-odbcapi30.o
.libs/psqlodbcw_la-pgapi30.o .libs/psqlodbcw_la-mylog.o
.libs/psqlodbcw_la-odbcapi30w.o .libs/psqlodbcw_la-odbcapiw.o
.libs/psqlodbcw_la-win_unicode.o   |  | /usr/bin/gsed 's/.* //' | sort |
uniq > .libs/psqlodbcw.exp
./libtool[1086]: eval: syntax error at line 1: `|' unexpected
*** Error code 3
make: Fatal error: Command failed for target `psqlodbcw.la'
Current working directory /root/psqlodbc13/psqlodbc-13.01.0000
*** Error code 1
make: Fatal error: Command failed for target `all'


I tried to use a different version of postgresql odbc driver, but with the
same problem.
I found a common error on this project
https://github.com/FreeTDS/freetds/issues/97 , but I couldn't fix it the
same way.