Horton

Extend pg_publication_tables to display column list and row filter.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: 0ff20288e1cb3282efb43401896a939916fceb4d
Author: Amit Kapila <akapila@postgresql.org>
Date: 2022-05-19T02:50:55Z
Releases: 15.0 
Extend pg_publication_tables to display column list and row filter.

Commit 923def9a53 and 52e4f0cd47 allowed to specify column lists and row
filters for publication tables. This commit extends the
pg_publication_tables view and pg_get_publication_tables function to
display that information.

This information will be useful to users and we also need this for the
later commit that prohibits combining multiple publications with different
column lists for the same table.

Author: Hou Zhijie
Reviewed By: Amit Kapila, Alvaro Herrera, Shi Yu, Takamichi Osumi
Discussion: https://postgr.es/m/202204251548.mudq7jbqnh7r@alvherre.pgsql

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +24 −3
src/backend/catalog/pg_publication.c modified +52 −2
src/backend/catalog/system_views.sql modified +9 −1
src/backend/replication/logical/tablesync.c modified +4 −10
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +4 −4
src/test/regress/expected/publication.out modified +21 −21
src/test/regress/expected/rules.out modified +11 −2

Documentation touched

Discussion