pg15 beta2 bug:cause by logcial replation - Mailing list pgsql-bugs

From 396934406@qq.com
Subject pg15 beta2 bug:cause by logcial replation
Date
Msg-id tencent_30262B030A662CC2DC8FF5D252C00D514B09@qq.com
Whole thread Raw
Responses RE: pg15 beta2 bug:cause by logcial replation  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
List pgsql-bugs
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


Test is ok  in pg15 beta1. 


396934406@qq.com

pgsql-bugs by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Auto-vacuum timing out and preventing connections
Next
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: pg15 beta2 bug:cause by logcial replation