Hi all, It looks that I forgot to mark pg_promote as parallel-restricted in 1007465 in pg_proc.dat. It seems to me that this is not a huge issue as system_views.sql redefines the function for its default values and enforces parallel-restricted, but let's be right from the start.
Attached is a patch to fix that. Any comments or objections? Please note that the catalog version bump is included as a personal reminder.. Thanks, -- Michael
diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h
index 1d5fe83c1a..f864420994 100644
--- a/src/include/catalog/catversion.h
+++ b/src/include/catalog/catversion.h
@@ -53,6 +53,6 @@
*/
/* yyyymmddN */
-#define CATALOG_VERSION_NO 201810251
+#define CATALOG_VERSION_NO 201810291
#endif
diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat
index 4d7fe1b383..8cf8a2f8fe 100644
--- a/src/include/catalog/pg_proc.dat
+++ b/src/include/catalog/pg_proc.dat
@@ -5825,7 +5825,7 @@
prorettype => 'timestamptz', proargtypes => '',
prosrc => 'pg_backup_start_time' },
{ oid => '3436', descr => 'promote standby server',
- proname => 'pg_promote', provolatile => 'v',
+ proname => 'pg_promote', provolatile => 'v', proparallel => 'r',
prorettype => 'bool', proargtypes => 'bool int4', proargnames => '{wait,wait_seconds}',
prosrc => 'pg_promote' },
{ oid => '2848', descr => 'switch to new wal file',
signature.asc
Description: PGP signature
