Re: How to discover what table is

Поиск
Список
Период
Сортировка
От PegoraroF10
Тема Re: How to discover what table is
Дата
Msg-id 1583914924920-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: How to discover what table is  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: How to discover what table is
Список pgsql-general
Well, for now it´s solved but I´ll explain what happens to solve it better on
future.
Suppose on Master you have a database with hundreds of schemas with same
structure, so table Customer happens 500 times on that DB. That database
being replicated with publication/subscription for all tables model, just
that. Now to have new schemas added to this database you go to replica,
create them with structure only, go to master and create them with data, go
back to replica and refresh publication. But then imagine that one of those
schemas you´ve created on replica with data. This is where problem occurs
and message is just PK of Table Customer is duplicated but is not easy to
find which table because I´ll have that table and that key on 90% of my
schemas. If, on error message we just have which schema belongs that table
would be great.



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Streaming replication - 11.5
Следующее
От: Torsten Krah
Дата:
Сообщение: Force WAL cleanup on running instance