Re: pub/sub - specifying optional parameters without values. - Mailing list pgsql-hackers

From Peter Smith
Subject Re: pub/sub - specifying optional parameters without values.
Date
Msg-id CAHut+Puy_mtvO7Zwb6PaRZyUYZ4yR1M2bMaqg_aorMHbrTbcWA@mail.gmail.com
Whole thread Raw
In response to Re: pub/sub - specifying optional parameters without values.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pub/sub - specifying optional parameters without values.
List pgsql-hackers
On Tue, Jan 31, 2023 at 4:00 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Peter Smith <smithpb2250@gmail.com> writes:
> > The v3 patch LGTM (just for the logical replication commands).
>
> Pushed then.
>

Thanks for pushing the v3 patch.

I'd forgotten about the 'streaming' option -- AFAIK this was
previously a boolean parameter and so its [= value] part can also be
omitted. However, in PG16 streaming became an enum type
(on/off/parallel), and the value can still be omitted but that is not
really being covered by the new generic text note about booleans added
by yesterday's patch.

e.g. The enum 'streaming' value part can still be omitted.
test_sub=# create subscription sub1 connection 'host=localhost
dbname=test_pub' publication pub1 with (streaming);

Perhaps a small top-up patch to CREATE SUBSCRIPTION is needed to
describe this special case?

PSA.

(I thought mentioning this special streaming case again for ALTER
SUBSCRIPTION might be overkill)

------
Kind Regards,
Peter Smith.
Fujitsu Australia

Attachment

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: Transparent column encryption
Next
From: Tom Lane
Date:
Subject: Re: pub/sub - specifying optional parameters without values.