From 689cef15de94aec192f211f84ca9cd2f1748e551 Mon Sep 17 00:00:00 2001 From: Thierry Parmentelat Date: Wed, 23 Nov 2022 15:52:52 +0100 Subject: [PATCH] fix in sql schema - for f37/pgsql14 (2) : will no longer work in f35/pgsql13 though array_append has changed its signature since postgresql13 --- planetlab5.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/planetlab5.sql b/planetlab5.sql index 61ff7fd..8dab501 100644 --- a/planetlab5.sql +++ b/planetlab5.sql @@ -40,10 +40,9 @@ INSERT INTO plc_db_version (version, subversion) VALUES (5, 100); -- Like MySQL GROUP_CONCAT(), this function aggregates values into a -- PostgreSQL array. -CREATE AGGREGATE array_accum ( +CREATE AGGREGATE array_accum(anycompatible) ( sfunc = array_append, - basetype = anyelement, - stype = anyarray, + stype = anycompatiblearray, initcond = '{}' ); -- 2.43.0