Re: Detecting renamed columns via pgouput in logical replication ?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Detecting renamed columns via pgouput in logical replication ?
Дата
Msg-id CAKFQuwZwe_Lw0vL=yG4q+sxuEUHoR28WeYbDHC6zKvuwYT=XBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Detecting renamed columns via pgouput in logical replication ?  (Andreas Andreakis <andreas.andreakis@gmail.com>)
Ответы Re: Detecting renamed columns via pgouput in logical replication ?
Список pgsql-general
Please don’t top-post.

On Monday, April 27, 2020, Andreas Andreakis <andreas.andreakis@gmail.com> wrote:
Thx for replying David.

According to https://www.postgresql.org/docs/10/protocol-logicalrep-message-formats.html it looks like certain schema information is embedded via pgoutput such as column names and types. However, if a new column name appears and a previous not, then it is currently not possible to differentiate if a column was renamed VS if a new column was added and an old dropped.

Correct.  Maybe you want event triggers?
 

There are additional schema changes that are currently not covered, such as changes in default values. 

Correct
 

Are there plans to add comprehensive schema change detection abilities via logical replication ? either by embedding more information into pgoutput or perhaps by embedding the schema DDLs ?  

You could search the mailing list archives for recent discussions but given the general lack fo response to your email I’d say probably not.  Decent odds if someone was they would have replied to your email.

David J.

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

Предыдущее
От: Andreas Andreakis
Дата:
Сообщение: Re: Detecting renamed columns via pgouput in logical replication ?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Detecting renamed columns via pgouput in logical replication ?