On Mon, Aug 4, 2025 at 4:37 PM David G. Johnston <david.g.johns...@gmail.com> wrote: > > On Sunday, August 3, 2025, Peter Smith <smithpb2...@gmail.com> wrote: >> >> Recently, I learned it is possible to say: >> >> CREATE PUBLICATION pub ... WITH (publish_generated_columns); >> >> This is equivalent to: >> CREATE PUBLICATION pub ... WITH (publish_generated_columns = stored); >> >> >> What is the verdict for this syntax -- ok or not? > > > Not. > > An enum should not allow for an omitted value. The documented policy of only > booleans being allowed an optional value is what is expected. I’d say this > is a new-in-18 bug that should be fixed in the code. The documentation is > correct - absence of the option means “none”, presence requires an explicit > value and not its own missing-value default. >
Thanks. That is the same as my understanding. I will post a patch to do this tomorrow. ====== Kind Regards, Peter Smith. Fujitsu Australia