Horton

Change publication's publish_generated_columns option type to enum.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: e65dbc9927fb86aa3c8a914ede6a6ae934384f5a
Author: Amit Kapila <akapila@postgresql.org>
Date: 2025-01-23T09:58:37Z
Releases: 18.0 
Change publication's publish_generated_columns option type to enum.

The current boolean publish_generated_columns option only supports a
binary choice, which is insufficient for future enhancements where
generated columns can be of different types (e.g., stored or virtual). The
supported values for the publish_generated_columns option are 'none' and
'stored'.

Author: Vignesh C <vignesh21@gmail.com>
Reviewed-by: Peter Smith <smithpb2250@gmail.com>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/d718d219-dd47-4a33-bb97-56e8fc4da994@eisentraut.org
Discussion: https://postgr.es/m/B80D17B2-2C8E-4C7D-87F2-E5B4BE3C069E@gmail.com

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +14 −0
doc/src/sgml/ref/create_publication.sgml modified +20 −9
src/backend/catalog/pg_publication.c modified +31 −5
src/backend/commands/publicationcmds.c modified +50 −18
src/backend/replication/logical/proto.c modified +45 −21
src/backend/replication/pgoutput/pgoutput.c modified +21 −15
src/backend/utils/cache/relcache.c modified +1 −1
src/bin/pg_dump/pg_dump.c modified +9 −8
src/bin/pg_dump/pg_dump.h modified +2 −1
src/bin/pg_dump/t/002_pg_dump.pl modified +2 −2
src/bin/psql/describe.c modified +16 −4
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_publication.h modified +22 −4
src/include/commands/publicationcmds.h modified +1 −1
src/include/replication/logicalproto.h modified +6 −5
src/test/regress/expected/publication.out modified +95 −84
src/test/regress/sql/publication.sql modified +23 −18
src/test/subscription/t/011_generated.pl modified +34 −33
src/tools/pgindent/typedefs.list modified +1 −0

Documentation touched

Discussion