From: Thierry Parmentelat <thierry.parmentelat@inria.fr>
Date: Wed, 23 Nov 2022 14:52:52 +0000 (+0100)
Subject: fix in sql schema - for f37/pgsql14 (2) : will no longer work in f35/pgsql13 though
X-Git-Url: http://git.onelab.eu/?p=plcapi.git;a=commitdiff_plain;h=689cef15de94aec192f211f84ca9cd2f1748e551

fix in sql schema - for f37/pgsql14 (2) : will no longer work in f35/pgsql13 though

array_append has changed its signature since postgresql13
---

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 = '{}'
 );