git://git.onelab.eu
/
plcapi.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
1193465
)
fix in sql schema - for f37/pgsql14 (2) : will no longer work in f35/pgsql13 though
author
Thierry Parmentelat
<thierry.parmentelat@inria.fr>
Wed, 23 Nov 2022 14:52:52 +0000
(15:52 +0100)
committer
Thierry Parmentelat
<thierry.parmentelat@inria.fr>
Wed, 23 Nov 2022 15:45:25 +0000
(16:45 +0100)
array_append has changed its signature since postgresql13
planetlab5.sql
patch
|
blob
|
history
diff --git
a/planetlab5.sql
b/planetlab5.sql
index
61ff7fd
..
8dab501
100644
(file)
--- 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 = '{}'
);