PostGres ODBC build error

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(at)capitecbank(dot)co(dot)za<mailto:ryantonkin(at)capitecbank(dot)co(dot)za>
[cid:image001(dot)png(at)01D8499D(dot)24D5BCB0]
T +27 72 418 2375 F +27 21 880 1130 M +27 72 418 2375
capitecbank.co.za<http://www.capitecbank.co.za/>