On Wed, May 22, 2019 at 4:57 PM Tom Lane <[email protected]> wrote: > > =?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= <[email protected]> writes: > > There are some case I missed to force us to use pg_get_publication_tables > > SRF instead of use pg_publication_rel ?? > > pg_publication_rel isn't going to provide the correct expansion of > a FOR ALL TABLES publication, IIUC. >
You're correct... there are a condition for it in pg_get_publication_tables and FOR ALL TABLES publications doesn't persist anything in pg_publication_rel. 497 publication = GetPublicationByName(pubname, false); 498 if (publication->alltables) 499 tables = GetAllTablesPublicationRelations(); 500 else 501 tables = GetPublicationRelations(publication->oid); Thanks for clarifying! Regards, -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
