From: 396934406@qq.com <396934406@qq.com>
To: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: pg15 beta2 bug:cause by logcial replation
Date: Fri, 1 Jul 2022 11:35:15 +0800
Message-ID: <tencent_30262B030A662CC2DC8FF5D252C00D514B09@qq.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: 396934406@qq.com, pgsql-bugs@lists.postgresql.org
Subject: Re: pg15 beta2 bug:cause by logcial replation
In-Reply-To: <tencent_30262B030A662CC2DC8FF5D252C00D514B09@qq.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox