Re: Detecting renamed columns via pgouput in logical replication ?

2020-04-30 Thread Alvaro Herrera
On 2020-Apr-27, Andreas Andreakis wrote: > 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 ? There aren't any plans currently that I am aware of. There

Re: Detecting renamed columns via pgouput in logical replication ?

2020-04-27 Thread David G. Johnston
On Monday, April 27, 2020, David G. Johnston wrote:. > > > 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 ar

Re: Detecting renamed columns via pgouput in logical replication ?

2020-04-27 Thread David G. Johnston
Please don’t top-post. On Monday, April 27, 2020, Andreas Andreakis 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.

Re: Detecting renamed columns via pgouput in logical replication ?

2020-04-27 Thread Andreas Andreakis
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 poss

Re: Detecting renamed columns via pgouput in logical replication ?

2020-04-26 Thread David G. Johnston
On Thursday, April 16, 2020, Andreas Andreakis wrote: > > > Does this allow to detect column renames ? > “The database schema and DDL commands are not replicated“ https://www.postgresql.org/docs/current/logical-replication-restrictions.html David J.

Detecting renamed columns via pgouput in logical replication ?

2020-04-16 Thread Andreas Andreakis
Hello, when using Postgres 10 or higher, it seems that pgoutput can be used as an output plugin for logical replication. Does this allow to detect column renames ? Or is there a ticket for adding support if the feature does not exist (if it is feasible to implement) ? https://www.postgresql.org/