Re: RE: pg15 beta2 bug:cause by logcial replation

 

From: houzj.fnst@fujitsu.com

Date: 2022-07-01 12:09

To: 396934406@qq.com

CC: pgsql-bugs

Subject: RE: pg15 beta2 bug:cause by logcial replation

On Friday, July 1, 2022 11:35 AM 396934406@qq.com <396934406@qq.com>  wrote:

> hello,:

>

>   i am jerome Peng,  from pg15 beta2  changes since beta 1 , i test this item and found a error:

>

> ? pg_publication_tables now provides information on column lists and row filters.

>

> \c logical_src

> create table tab1(id int primary key,info varchar);

> create table tab2(id int primary key,info1 varchar,info2 varchar);

> select pg_create_logical_replication_slot('logical_slot1','pgoutput');

> create publication pub_two for table tab1, tab2;

>

> \c logical_dest

> create table tab1(id int primary key,info varchar);

> create table tab2(id int primary key,info1 varchar,info2 varchar);

> create subscription sub_two

>  connection 'hostaddr=127.0.0.1 port=1501 user=postgres dbname=logical_src'

>  publication pub_two with(create_slot='false',slot_name='logical_slot1');

>

> ERROR:  could not receive list of replicated tables from the publisher: ERROR:  column t.attnames does not exist

> LINE 2: , t.attnames

 

Hi,

 

I tried your reproduction steps but cannot get the same error.

 

Can you please provide some more information about the version

of publisher and subscriber you used ?

 

Just to confirm, did you use the PG15 beta1 or earlier PG15 version

as the publisher and use PG15 beta2 as the subscriber ?

 

Best regards,

Hou zj