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

From: 396934406@qq.com <396934406@qq.com>
Sent: Friday, July 1, 2022 2:37 PM
To: Hou, Zhijie <houzj.fnst@fujitsu.com>
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: RE: pg15 beta2 bug:cause by logcial replation

$ /opt/pg15-beta2/bin/psql -p1502

psql (15beta2)

Type "help" for help.

postgres=# drop database logical_src;

DROP DATABASE

postgres=# drop database logical_dest ;

DROP DATABASE

postgres=# select version();

                                                  version                                                   

------------------------------------------------------------------------------------------------------------

 PostgreSQL 15beta2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit

(1 row)

postgres=# create database logical_src;

CREATE DATABASE

postgres=# create database logical_dest;

CREATE DATABASE

postgres=# \c logical_src

You are now connected to database "logical_src" as user "postgres".

logical_src=# create table tab1(id int primary key,info varchar);

CREATE TABLE

logical_src=# create table tab2(id int primary key,info1 varchar,info2 varchar);

CREATE TABLE

logical_src=# select pg_create_logical_replication_slot('logical_slot1','pgoutput');

 pg_create_logical_replication_slot 

------------------------------------

 (logical_slot1,0/4976D9D8)

(1 row)

logical_src=# create publication pub_two for table tab1, tab2;

CREATE PUBLICATION

logical_src=# \c logical_dest

You are now connected to database "logical_dest" as user "postgres".

logical_dest=# create table tab1(id int primary key,info varchar);

CREATE TABLE

logical_dest=# create table tab2(id int primary key,info1 varchar,info2 varchar);

CREATE TABLE

logical_dest=# create subscription sub_two 

logical_dest-#  connection 'hostaddr=127.0.0.1 port=1501 user=postgres dbname=logical_src' 

logical_dest-#  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

          ^