RE: pg15 beta2 bug:cause by logcial replation

On Friday, July 1, 2022 11:35 AM 396934406(at)qq(dot)com <396934406(at)qq(dot)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