diff options
| author | Amit Kapila <akapila@postgresql.org> | 2022-05-19 08:20:55 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2022-05-19 08:20:55 +0530 |
| commit | 0ff20288e1cb3282efb43401896a939916fceb4d (patch) | |
| tree | c92b34d13bd072e0c06127b3a8640a25ea4dc917 /src/include/catalog/pg_proc.dat | |
| parent | 62221ef187b0098c8f331f804b7c63859e5ee6ff (diff) | |
| download | postgresql-0ff20288e1cb3282efb43401896a939916fceb4d.tar.gz | |
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
Diffstat (limited to 'src/include/catalog/pg_proc.dat')
| -rw-r--r-- | src/include/catalog/pg_proc.dat | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat index babe16f00a..87aa571a33 100644 --- a/src/include/catalog/pg_proc.dat +++ b/src/include/catalog/pg_proc.dat @@ -11673,11 +11673,11 @@ prosrc => 'pg_show_replication_origin_status' }, # publications -{ oid => '6119', descr => 'get OIDs of tables in a publication', +{ oid => '6119', descr => 'get information of tables in a publication', proname => 'pg_get_publication_tables', prorows => '1000', proretset => 't', - provolatile => 's', prorettype => 'oid', proargtypes => 'text', - proallargtypes => '{text,oid}', proargmodes => '{i,o}', - proargnames => '{pubname,relid}', prosrc => 'pg_get_publication_tables' }, + provolatile => 's', prorettype => 'record', proargtypes => 'text', + proallargtypes => '{text,oid,int2vector,pg_node_tree}', proargmodes => '{i,o,o,o}', + proargnames => '{pubname,relid,attrs,qual}', prosrc => 'pg_get_publication_tables' }, { oid => '6121', descr => 'returns whether a relation can be part of a publication', proname => 'pg_relation_is_publishable', provolatile => 's', |