Commit26f36fe

committed

Doc: avoid using pg_get_publication_tables() in an example.

pg_get_publication_tables() is undocumented because it's only meantas infrastructure for the pg_publication_tables system view.That being the case, we should use the view not the bare functionin this sample query.Shi YuDiscussion:https://postgr.es/m/OSZPR01MB63107E83D07FEDEEABD83A23FD949@OSZPR01MB6310.jpnprd01.prod.outlook.com

1 parent6ff2e8c commit26f36feCopy full SHA for 26f36fe

File tree

-6

lines changed

-6

lines changed

Lines changed: 8 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -496,12 +496,14 @@ CREATE SUBSCRIPTION <replaceable class="parameter">subscription_name</replaceabl`
`496`	`496`	`other subscriptions created on the publisher) try this SQL query:`
`497`	`497`	`<programlisting>`
`498`	`498`	`# substitute <pub-names> below with your publication name(s) to be queried`
`499`		`-SELECT DISTINCT N.nspname AS schemaname, C.relname AS tablename`
`500`		`-FROM pg_publication P,`
`501`		`- LATERAL pg_get_publication_tables(P.pubname) GPT`
`502`		`- JOIN pg_subscription_rel PS ON (GPT.relid = PS.srrelid),`
`503`		`- pg_class C JOIN pg_namespace N ON (N.oid = C.relnamespace)`
`504`		`-WHERE C.oid = GPT.relid AND P.pubname IN (<pub-names>);`
	`499`	`+SELECT DISTINCT PT.schemaname, PT.tablename`
	`500`	`+FROM pg_publication_tables PT,`
	`501`	`+ pg_subscription_rel PS`
	`502`	`+ JOIN pg_class C ON (C.oid = PS.srrelid)`
	`503`	`+ JOIN pg_namespace N ON (N.oid = C.relnamespace)`
	`504`	`+WHERE N.nspname = PT.schemaname AND`
	`505`	`+ C.relname = PT.tablename AND`
	`506`	`+ PT.pubname IN (<pub-names>);`
`505`	`507`	`</programlisting></para>`
`506`	`508`
`507`	`509`	`</refsect1>`

Comments

(0)