=?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= writes:
> Em ter, 21 de mai de 2019 às 14:41, Tom Lane escreveu:
>> It's a view, not a table, so I don't think you need
>> allow_system_table_mods. A quick test here says that being
>> superuser is enough to do a CREATE OR REPLACE VIEW on it.
> Interesti
Em ter, 21 de mai de 2019 às 14:41, Tom Lane escreveu:
>
> =?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= writes:
> > 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_publi
=?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= writes:
> 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 us
I cannot because we created a replication for ALL TABLES
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
Em seg, 20 de mai de 2019 às 18:30, Tom Lane escreveu:
>
> Hmm ... given that pg_get_publication_tables() shouldn't return any
> duplicate OIDs, it does seem unnecessarily inefficient to put it in
> an IN-subselect condition. Peter, is there a reason why this isn't
> a straight lateral join? I g
PegoraroF10 writes:
> I tried sometime ago ... but with no responses, I ask you again.
> pg_publication_tables is a view that is used to refresh publication, but as
> we have 15.000 tables, it takes hours and doesn´t complete. If I change that
> view I can have an immediate result. The question is
