openrem with Postgresql 14 crashes

Hi

A recent system upgrade took my Postgresql installation to version 14. I attempted to update the openrem database by postgreqsql-upgrade but according to the log it failed with:

pg_restore: error: could not execute query: ERROR: function array_append(anyarray, anyelement) does not exist
Command was: CREATE AGGREGATE "public"."median"("anyelement") (
SFUNC = "array_append",
STYPE = "anyarray",
INITCOND = '{}',
FINALFUNC = "public"."_final_median"
);

I then wiped the databases and started with a fresh install. When I executed:

python manage.py migrate

I got:

File "/home/openrem/env/lib/python3.10/site-packages/django/db/backends/utils.py", line 82, in _execute
return self.cursor.execute(sql)
psycopg2.errors.UndefinedFunction: function array_append(anyarray, anyelement) does not exist

According to this website:

https://postgrespro.com/list/thread-id/2552349

the parameters of the function array_append(anyarray, anyelement) have changed to (anycompatiblearray, anycompatible) in Postgres 14

As a workaround I will try and revert to Postgres 13.

Regards

Alan

‌

Comments (6)