Re: pub/sub - specifying optional parameters without values.

Zheng Li <zhengli10@gmail.com>

From: Zheng Li <zhengli10@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Peter Smith <smithpb2250@gmail.com>
Date: 2023-01-09T17:37:05Z
Lists: pgsql-hackers
Hi,

This documentation change looks good to me. I verified in testing and in code that the value for boolean parameters in PUB/SUB commands can be omitted. which is equivalent to specifying TRUE. For example,

CREATE PUBLICATIOIN mypub for ALL TABLES with (publish_via_partition_root);
is equivalent to
CREATE PUBLICATIOIN mypub for ALL TABLES with (publish_via_partition_root = TRUE);

The behavior is due to the following code
https://github.com/postgres/postgres/blob/master/src/backend/commands/define.c#L113

Marking this as ready for committer.

The new status of this patch is: Ready for Committer

Commits

  1. Doc: clarify behavior of boolean options in replication protocol commands.

  2. Doc: clarify behavior of boolean options in replication commands.