aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2018-05-07 13:13:27 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2018-05-07 13:13:45 -0400
commite71d9f6951fa61f386bebe3c97735a80def8a1e2 (patch)
tree206269cfad0c7eec7051a1cad76583732ea0c005
parent2a771988f4daf6495ab63e9cb69c9d3a84eca1f0 (diff)
downloadpostgresql-e71d9f6951fa61f386bebe3c97735a80def8a1e2.tar.gz
postgresql-e71d9f6951fa61f386bebe3c97735a80def8a1e2.zip
Last-minute updates for release notes.
The set of functions that need parallel-safety adjustments isn't the same in 9.6 as 10, so I shouldn't have blindly back-patched that list. Adjust as needed. Also, provide examples of the commands to issue.
-rw-r--r--doc/src/sgml/release-9.3.sgml10
-rw-r--r--doc/src/sgml/release-9.4.sgml10
-rw-r--r--doc/src/sgml/release-9.5.sgml10
-rw-r--r--doc/src/sgml/release-9.6.sgml27
4 files changed, 32 insertions, 25 deletions
diff --git a/doc/src/sgml/release-9.3.sgml b/doc/src/sgml/release-9.3.sgml
index 2bab3894448..054ef1c37f1 100644
--- a/doc/src/sgml/release-9.3.sgml
+++ b/doc/src/sgml/release-9.3.sgml
@@ -59,10 +59,12 @@
installations will continue to contain the incorrect markings.
Practical use of these functions seems to pose little hazard, but in
case of trouble, it can be fixed by manually updating these
- functions' <structname>pg_proc</structname> entries. (Note that that
- will need to be done in each database of the installation.) Another
- option is to <application>pg_upgrade</application> the database to a
- version containing the corrected initial data.
+ functions' <structname>pg_proc</structname> entries, for example
+ <literal>ALTER FUNCTION pg_catalog.query_to_xml(text, boolean,
+ boolean, text) VOLATILE</literal>. (Note that that will need to be
+ done in each database of the installation.) Another option is
+ to <application>pg_upgrade</application> the database to a version
+ containing the corrected initial data.
</para>
</listitem>
diff --git a/doc/src/sgml/release-9.4.sgml b/doc/src/sgml/release-9.4.sgml
index 67d3f2e3a37..d368990a841 100644
--- a/doc/src/sgml/release-9.4.sgml
+++ b/doc/src/sgml/release-9.4.sgml
@@ -59,10 +59,12 @@
installations will continue to contain the incorrect markings.
Practical use of these functions seems to pose little hazard, but in
case of trouble, it can be fixed by manually updating these
- functions' <structname>pg_proc</structname> entries. (Note that that
- will need to be done in each database of the installation.) Another
- option is to <application>pg_upgrade</application> the database to a
- version containing the corrected initial data.
+ functions' <structname>pg_proc</structname> entries, for example
+ <literal>ALTER FUNCTION pg_catalog.query_to_xml(text, boolean,
+ boolean, text) VOLATILE</literal>. (Note that that will need to be
+ done in each database of the installation.) Another option is
+ to <application>pg_upgrade</application> the database to a version
+ containing the corrected initial data.
</para>
</listitem>
diff --git a/doc/src/sgml/release-9.5.sgml b/doc/src/sgml/release-9.5.sgml
index 99fc9645a4b..4c19c342c80 100644
--- a/doc/src/sgml/release-9.5.sgml
+++ b/doc/src/sgml/release-9.5.sgml
@@ -59,10 +59,12 @@
installations will continue to contain the incorrect markings.
Practical use of these functions seems to pose little hazard, but in
case of trouble, it can be fixed by manually updating these
- functions' <structname>pg_proc</structname> entries. (Note that that
- will need to be done in each database of the installation.) Another
- option is to <application>pg_upgrade</application> the database to a
- version containing the corrected initial data.
+ functions' <structname>pg_proc</structname> entries, for example
+ <literal>ALTER FUNCTION pg_catalog.query_to_xml(text, boolean,
+ boolean, text) VOLATILE</literal>. (Note that that will need to be
+ done in each database of the installation.) Another option is
+ to <application>pg_upgrade</application> the database to a version
+ containing the corrected initial data.
</para>
</listitem>
diff --git a/doc/src/sgml/release-9.6.sgml b/doc/src/sgml/release-9.6.sgml
index 4165287057b..847889c51d6 100644
--- a/doc/src/sgml/release-9.6.sgml
+++ b/doc/src/sgml/release-9.6.sgml
@@ -91,10 +91,12 @@
installations will continue to contain the incorrect markings.
Practical use of these functions seems to pose little hazard, but in
case of trouble, it can be fixed by manually updating these
- functions' <structname>pg_proc</structname> entries. (Note that that
- will need to be done in each database of the installation.) Another
- option is to <application>pg_upgrade</application> the database to a
- version containing the corrected initial data.
+ functions' <structname>pg_proc</structname> entries, for example
+ <literal>ALTER FUNCTION pg_catalog.query_to_xml(text, boolean,
+ boolean, text) VOLATILE</literal>. (Note that that will need to be
+ done in each database of the installation.) Another option is
+ to <application>pg_upgrade</application> the database to a version
+ containing the corrected initial data.
</para>
</listitem>
@@ -107,15 +109,12 @@
<para>
The functions
<function>brin_summarize_new_values</function>,
- <function>brin_summarize_range</function>,
- <function>brin_desummarize_range</function>,
<function>gin_clean_pending_list</function>,
<function>cursor_to_xml</function>,
<function>cursor_to_xmlschema</function>,
<function>ts_rewrite</function>,
- <function>ts_stat</function>,
- <function>binary_upgrade_create_empty_extension</function>, and
- <function>pg_import_system_collations</function>
+ <function>ts_stat</function>, and
+ <function>binary_upgrade_create_empty_extension</function>
should be marked parallel-unsafe; some because they perform database
modifications directly, and others because they execute user-supplied
queries that might do so. They were marked parallel-restricted
@@ -125,10 +124,12 @@
incorrect markings. Practical use of these functions seems to pose
little hazard unless <varname>force_parallel_mode</varname> is turned
on. In case of trouble, it can be fixed by manually updating these
- functions' <structname>pg_proc</structname> entries. (Note that that
- will need to be done in each database of the installation.) Another
- option is to <application>pg_upgrade</application> the database to a
- version containing the corrected initial data.
+ functions' <structname>pg_proc</structname> entries, for example
+ <literal>ALTER FUNCTION pg_catalog.brin_summarize_new_values(regclass)
+ PARALLEL UNSAFE</literal>. (Note that that will need to be done in
+ each database of the installation.) Another option is
+ to <application>pg_upgrade</application> the database to a version
+ containing the corrected initial data.
</para>
</listitem>