Arch Linux User Repository

Newer versions of this (>16) do not support linux at the moment, see https://github.com/postgresql-interfaces/psqlodbc/issues/28. Once this has been resolved, I'll update it.

As of 28th May installation fails with:

curl: (22) The requested URL returned error: 404
==> ERROR: Failure while downloading https://ftp.postgresql.org/pub/odbc/versions/src/psqlodbc-16.00.0000.tar.gz

Workaround - edit pkgbuild before installation (e.g. paru -Syu --fm vim) Change source line in PKGBUILD from:

source=(https://ftp.postgresql.org/pub/odbc/versions/src/psqlodbc-$pkgver.tar.gz)

to

source=(https://ftp.postgresql.org/pub/odbc/versions.old/src/psqlodbc-$pkgver.tar.gz)

For me, this fails with:

libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/usr/include -I/usr/include -I/usr/include/postgresql/internal -DUNICODE_SUPPORT -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security -fstack-clash-protection -fcf-protection -MT psqlodbcw_la-info.lo -MD -MP -MF .deps/psqlodbcw_la-info.Tpo -c info.c  -fPIC -DPIC -o .libs/psqlodbcw_la-info.o
In file included from statement.h:15,
                 from bind.c:23:
/usr/include/postgresql/internal/pqexpbuffer.h:168:8: error: unknown type name 'bool'
  168 | extern bool appendPQExpBufferVA(PQExpBuffer str, const char *fmt, va_list args) pg_attribute_printf(2, 0);
      |        ^~~~
In file included from connection.h:14,
                 from info.c:34:
/usr/include/postgresql/internal/pqexpbuffer.h:168:8: error: unknown type name 'bool'
  168 | extern bool appendPQExpBufferVA(PQExpBuffer str, const char *fmt, va_list args) pg_attribute_printf(2, 0);
      |        ^~~~
make[1]: *** [Makefile:664: psqlodbcw_la-bind.lo] Error 1

I guess my gcc doesn't like c language 'bool' types.

I think the instructions in psqlodbc.install need to change the library file referenced from psqlodbca.so to psqlodbcw.so.

The former is the ASCII driver, I believe.