PostGres ODBC build error - Mailing list pgsql-odbc

Hello

I hope you are well.  I was wondering if you could help me with the below error.

When I attempt to run “make” after having done ./configure, it gives me the error below:

libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/opt/include -I/usr/include -I/usr/include/pgsql/internal -DUNICODE_SUPPORT -g -O2 -Wall -MT psqlodbcw_la-bind.lo -MD -MP -MF .deps/psqlodbcw_la-bind.Tpo -c bind.c  -fPIC -DPIC -o .libs/psqlodbcw_la-bind.o
mv -f .deps/psqlodbcw_la-bind.Tpo .deps/psqlodbcw_la-bind.Plo
/bin/sh ./libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.   -I/opt/include -I/usr/include -I/usr/include/pgsql/internal -DUNICODE_SUPPORT  -g -O2 -Wall -MT psqlodbcw_la-columninfo.lo -MD -MP -MF .deps/psqlodbcw_la-columninfo.Tpo -c -o psqlodbcw_la-columninfo.lo `test -f 'columninfo.c' || echo './'`columninfo.c
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/opt/include -I/usr/include -I/usr/include/pgsql/internal -DUNICODE_SUPPORT -g -O2 -Wall -MT psqlodbcw_la-columninfo.lo -MD -MP -MF .deps/psqlodbcw_la-columninfo.Tpo -c columninfo.c  -fPIC -DPIC -o .libs/psqlodbcw_la-columninfo.o
mv -f .deps/psqlodbcw_la-columninfo.Tpo .deps/psqlodbcw_la-columninfo.Plo
/bin/sh ./libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.   -I/opt/include -I/usr/include -I/usr/include/pgsql/internal -DUNICODE_SUPPORT  -g -O2 -Wall -MT psqlodbcw_la-connection.lo -MD -MP -MF .deps/psqlodbcw_la-connection.Tpo -c -o psqlodbcw_la-connection.lo `test -f 'connection.c' || echo './'`connection.c
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/opt/include -I/usr/include -I/usr/include/pgsql/internal -DUNICODE_SUPPORT -g -O2 -Wall -MT psqlodbcw_la-connection.lo -MD -MP -MF .deps/psqlodbcw_la-connection.Tpo -c connection.c  -fPIC -DPIC -o .libs/psqlodbcw_la-connection.o
connection.c: In function 'handle_pgres_error':
connection.c:900:45: error: 'PG_DIAG_SCHEMA_NAME' undeclared (first use in this function)
   errschemaname = PQresultErrorField(pgres, PG_DIAG_SCHEMA_NAME);
                                             ^
connection.c:900:45: note: each undeclared identifier is reported only once for each function it appears in
connection.c:901:44: error: 'PG_DIAG_TABLE_NAME' undeclared (first use in this function)
   errtablename = PQresultErrorField(pgres, PG_DIAG_TABLE_NAME);
                                            ^
connection.c:902:45: error: 'PG_DIAG_COLUMN_NAME' undeclared (first use in this function)
   errcolumnname = PQresultErrorField(pgres, PG_DIAG_COLUMN_NAME);
                                             ^
connection.c:903:47: error: 'PG_DIAG_DATATYPE_NAME' undeclared (first use in this function)
   errdatatypename = PQresultErrorField(pgres, PG_DIAG_DATATYPE_NAME);
                                               ^
make[1]: *** [psqlodbcw_la-connection.lo] Error 1
make[1]: Leaving directory `/opt/postgres/lib/psqlodbc-13.00.0000'
make: *** [all] Error 2

Kind regards

Ryan Tonkin

Data and Analytics – Business Bank

Data Engineer

ryantonkin@capitecbank.co.za

T +27 72 418 2375  F +27 21 880 1130  M +27 72 418 2375
capitecbank.co.za