postgres
diff --git a/‎src/backend/catalog/pg_publication.c
Copy file name to clipboardExpand all lines: src/backend/catalog/pg_publication.c
+1-1Lines changed: 1 addition & 1 deletion b/‎src/backend/catalog/pg_publication.c
Copy file name to clipboardExpand all lines: src/backend/catalog/pg_publication.c
+1-1Lines changed: 1 addition & 1 deletion
diff --git a/‎src/backend/optimizer/util/plancat.c
Copy file name to clipboardExpand all lines: src/backend/optimizer/util/plancat.c
+2-1Lines changed: 2 additions & 1 deletion b/‎src/backend/optimizer/util/plancat.c
Copy file name to clipboardExpand all lines: src/backend/optimizer/util/plancat.c
+2-1Lines changed: 2 additions & 1 deletion
diff --git a/‎src/test/subscription/t/001_rep_changes.pl
Copy file name to clipboardExpand all lines: src/test/subscription/t/001_rep_changes.pl
+19-1Lines changed: 19 additions & 1 deletion b/‎src/test/subscription/t/001_rep_changes.pl
Copy file name to clipboardExpand all lines: src/test/subscription/t/001_rep_changes.pl
+19-1Lines changed: 19 additions & 1 deletion
@@ -67,7 +67,7 @@ check_publication_add_relation(Relation targetrel)
 				 errdetail("System tables cannot be added to publications.")));
 
 	/* UNLOGGED and TEMP relations cannot be part of publication. */
-	if (!RelationNeedsWAL(targetrel))
+	if (targetrel->rd_rel->relpersistence != RELPERSISTENCE_PERMANENT)
 		ereport(ERROR,
 				(errcode(ERRCODE_INVALID_PARAMETER_VALUE),
 				 errmsg("table \"%s\" cannot be replicated",
 
@@ -126,7 +126,8 @@ get_relation_info(PlannerInfo *root, Oid relationObjectId, bool inhparent,
 	relation = table_open(relationObjectId, NoLock);
 
 	/* Temporary and unlogged relations are inaccessible during recovery. */
-	if (!RelationNeedsWAL(relation) && RecoveryInProgress())
+	if (relation->rd_rel->relpersistence != RELPERSISTENCE_PERMANENT &&
+		RecoveryInProgress())
 		ereport(ERROR,
 				(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
 				 errmsg("cannot access temporary or unlogged relations during recovery")));
 
@@ -3,7 +3,7 @@
 use warnings;
 use PostgresNode;
 use TestLib;
-use Test::More tests => 27;
+use Test::More tests => 28;
 
 # Initialize publisher node
 my $node_publisher = get_new_node('publisher');
@@ -451,3 +451,21 @@
 
 $node_subscriber->stop('fast');
 $node_publisher->stop('fast');
+
+# CREATE PUBLICATION while wal_level=minimal should succeed, with a WARNING
+$node_publisher->append_conf(
+	'postgresql.conf', qq(
+wal_level=minimal
+max_wal_senders=0
+));
+$node_publisher->start;
+($result, my $retout, my $reterr) = $node_publisher->psql(
+	'postgres', qq{
+BEGIN;
+CREATE TABLE skip_wal();
+CREATE PUBLICATION tap_pub2 FOR TABLE skip_wal;
+ROLLBACK;
+});
+ok( $reterr =~
+	  m/WARNING:  wal_level is insufficient to publish logical changes/,
+	'CREATE PUBLICATION while wal_level=minimal');