Em ter, 21 de mai de 2019 às 14:17, PegoraroF10 <mar...@f10.com.br> escreveu: > > Restart Postgres means exactly what ? We tried just restart the service but > we tried to refresh publication the old view was used because it took 2hours > and gave us a timeout. >
As I said before to change system catalog you should set "allow_system_table_mods=on" and restart PostgreSQL service. After that you'll able to recreate the "pg_catalog.pg_publication_tables" system view. (You can use the Tom's suggestion using LATERAL) Regards, -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento