From daa0f22b63c1442ad51122e5ba140c1ae5890267 Mon Sep 17 00:00:00 2001 From: Daniel Golle Date: Sun, 27 Sep 2020 19:55:09 +0100 Subject: postgres: drop use of 'WITH OIDS' PostgreSQL since version 12 no longer supports 'WITH OIDS': Previously, a normally-invisible oid column could be specified during table creation using WITH OIDS; that ability has been removed. Columns can still be explicitly declared as type oid. Operations on tables that have columns created using WITH OIDS will need adjustment. The system catalogs that previously had hidden oid columns now have ordinary oid columns. Hence, SELECT * will now output those columns, whereas previously they would be displayed only if selected explicitly. Drop 'WITH OIDS' as it was stated even on tables for plugins which didn't make any use of the then exposed 'oid' column. In the case of datacache and datastore the 'oid' column is used, so replace the 'WITH OIDS' statement with an explicit 'oid' column having 'OID' type and a corresponding sequence. No measures are taken to still work with PostgreSQL before version 12. Users should update PostgreSQL to version 12 or newer. Signed-off-by: Daniel Golle --- configure.ac | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'configure.ac') diff --git a/configure.ac b/configure.ac index 946b6f58a..581764b52 100644 --- a/configure.ac +++ b/configure.ac @@ -1335,7 +1335,7 @@ CPPFLAGS=$SAVE_CPPFLAGS # test for postgres: postgres=false -AX_LIB_POSTGRESQL([9.5], +AX_LIB_POSTGRESQL([12.0], [CPPFLAGS="$CPPFLAGS $POSTGRESQL_CPPFLAGS" AC_CHECK_HEADERS([libpq-fe.h], postgres=true) -- cgit v1.2.3