Commit6f81306

committed

Downgrade subscription refresh messages to DEBUG1

The NOTICE messages about tables being added or removed duringsubscription refresh would be incorrect and possibly confusing if thetransaction rolls back, so silence them but keep them available fordebugging.Discussion:https://www.postgresql.org/message-id/CAD21AoAvaXizc2h7aiNyK_i0FQSa-tmhpdOGwbhh7Jy544Ad4Q%40mail.gmail.com

1 parent655727d commit6f81306Copy full SHA for 6f81306

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -572,7 +572,7 @@ AlterSubscription_refresh(Subscription *sub, bool copy_data)`
`572`	`572`	`SetSubscriptionRelState(sub->oid,relid,`
`573`	`573`	`copy_data ?SUBREL_STATE_INIT :SUBREL_STATE_READY,`
`574`	`574`	`InvalidXLogRecPtr, false);`
`575`		`-ereport(NOTICE,`
	`575`	`+ereport(DEBUG1,`
`576`	`576`	`(errmsg("added subscription for table %s.%s",`
`577`	`577`	`quote_identifier(rv->schemaname),`
`578`	`578`	`quote_identifier(rv->relname))));`
`@@ -600,7 +600,7 @@ AlterSubscription_refresh(Subscription *sub, bool copy_data)`
`600`	`600`	`logicalrep_worker_stop_at_commit(sub->oid,relid);`
`601`	`601`
`602`	`602`	`namespace=get_namespace_name(get_rel_namespace(relid));`
`603`		`-ereport(NOTICE,`
	`603`	`+ereport(DEBUG1,`
`604`	`604`	`(errmsg("removed subscription for table %s.%s",`
`605`	`605`	`quote_identifier(namespace),`
`606`	`606`	`quote_identifier(get_rel_name(relid)))));`

Comments

(0)