pg15 beta2 bug:cause by logcial replation

From: "396934406(at)qq(dot)com" <396934406(at)qq(dot)com>
To: pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: pg15 beta2 bug:cause by logcial replation
Date: 2022-07-01 03:35:15
Message-ID: tencent_30262B030A662CC2DC8FF5D252C00D514B09@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)qq(dot)com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message houzj.fnst@fujitsu.com 2022-07-01 04:09:22 RE: pg15 beta2 bug:cause by logcial replation
Previous Message Masahiko Sawada 2022-06-30 02:22:35 Re: Auto-vacuum timing out and preventing connections