aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2021-06-14 12:49:05 -0400
committerBruce Momjian <bruce@momjian.us>2021-06-14 12:49:05 -0400
commit25dfb5a831a1b8a83a8a68453b4bbe38a5ef737e (patch)
tree8623f1bbcf7584c29a013db49ec73f82883e14e4
parent2d689babe3cb50dcb29f6ed595a61d56e518c0d8 (diff)
downloadpostgresql-25dfb5a831a1b8a83a8a68453b4bbe38a5ef737e.tar.gz
postgresql-25dfb5a831a1b8a83a8a68453b4bbe38a5ef737e.zip
doc: add PG 14 relnote item about array function references
User-defined objects that reference some built-in array functions will need to be recreated in PG 14. Reported-by: Justin Pryzby Discussion: https://postgr.es/m/20210608225618.GR16435@telsasoft.com
-rw-r--r--doc/src/sgml/release-14.sgml29
1 files changed, 29 insertions, 0 deletions
diff --git a/doc/src/sgml/release-14.sgml b/doc/src/sgml/release-14.sgml
index 058ba7cd4eb..c2d89412062 100644
--- a/doc/src/sgml/release-14.sgml
+++ b/doc/src/sgml/release-14.sgml
@@ -291,6 +291,35 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
<listitem>
<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
+2020-11-04 [9e38c2bb5] Declare assorted array functions using anycompatible not
+-->
+
+ <para>
+ User-defined objects that reference some built-in array functions
+ along with their argument types must be recreated (Tom Lane)
+ </para>
+
+ <para>
+ Specifically, <link
+ linkend="functions-array"><function>array_append()</function></link>,
+ <function>array_prepend()</function>,
+ <function>array_cat()</function>,
+ <function>array_position()</function>,
+ <function>array_positions()</function>,
+ <function>array_remove()</function>,
+ <function>array_replace()</function>, or <link
+ linkend="functions-math"><function>width_bucket()</function></link>
+ used to take <type>anyarray</type> arguments but now take
+ <type>anycompatiblearray</type>. Therefore, user-defined objects
+ like aggregates and operators that reference old array function
+ signatures must be dropped before upgrading and recreated once the
+ upgrade completes.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
2020-09-17 [76f412ab3] Remove factorial operators, leaving only the factorial()
-->