Message-ID: <tencent_260F8B0DF71A3DBB1469C3E912B84AC90207@qq.com>
Date: Fri, 1 Jul 2022 14:36:52 +0800
From: "396934406@qq.com" <396934406@qq.com>
To: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: RE: pg15 beta2 bug:cause by logcial replation
References: <tencent_30262B030A662CC2DC8FF5D252C00D514B09@qq.com>,
	 <OS0PR01MB571689015E31F1AF1784350094BD9@OS0PR01MB5716.jpnprd01.prod.outlook.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_001_NextPart727446812337_=----"
Archived-At: 
 <https://www.postgresql.org/message-id/tencent_260F8B0DF71A3DBB1469C3E912B84AC90207%40qq.com>
Precedence: bulk

This is a multi-part message in MIME format.

------=_001_NextPart727446812337_=----
Content-Type: text/plain;
	charset="iso-2022-jp"
Content-Transfer-Encoding: base64

JCAvb3B0L3BnMTUtYmV0YTIvYmluL3BzcWwgLXAxNTAyDQpwc3FsICgxNWJldGEyKQ0KVHlwZSAi
aGVscCIgZm9yIGhlbHAuDQoNCnBvc3RncmVzPSMgZHJvcCBkYXRhYmFzZSBsb2dpY2FsX3NyYzsN
CkRST1AgREFUQUJBU0UNCnBvc3RncmVzPSMgZHJvcCBkYXRhYmFzZSBsb2dpY2FsX2Rlc3QgOw0K
RFJPUCBEQVRBQkFTRQ0KcG9zdGdyZXM9IyBzZWxlY3QgdmVyc2lvbigpOw0KICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB2ZXJzaW9uICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBQb3N0Z3JlU1FMIDE1YmV0YTIg
b24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDQuOC41IDIwMTUw
NjIzIChSZWQgSGF0IDQuOC41LTM2KSwgNjQtYml0DQooMSByb3cpDQoNCnBvc3RncmVzPSMgY3Jl
YXRlIGRhdGFiYXNlIGxvZ2ljYWxfc3JjOw0KQ1JFQVRFIERBVEFCQVNFDQpwb3N0Z3Jlcz0jIGNy
ZWF0ZSBkYXRhYmFzZSBsb2dpY2FsX2Rlc3Q7DQpDUkVBVEUgREFUQUJBU0UNCnBvc3RncmVzPSMg
XGMgbG9naWNhbF9zcmMNCllvdSBhcmUgbm93IGNvbm5lY3RlZCB0byBkYXRhYmFzZSAibG9naWNh
bF9zcmMiIGFzIHVzZXIgInBvc3RncmVzIi4NCmxvZ2ljYWxfc3JjPSMgY3JlYXRlIHRhYmxlIHRh
YjEoaWQgaW50IHByaW1hcnkga2V5LGluZm8gdmFyY2hhcik7DQpDUkVBVEUgVEFCTEUNCmxvZ2lj
YWxfc3JjPSMgY3JlYXRlIHRhYmxlIHRhYjIoaWQgaW50IHByaW1hcnkga2V5LGluZm8xIHZhcmNo
YXIsaW5mbzIgdmFyY2hhcik7DQpDUkVBVEUgVEFCTEUNCmxvZ2ljYWxfc3JjPSMgc2VsZWN0IHBn
X2NyZWF0ZV9sb2dpY2FsX3JlcGxpY2F0aW9uX3Nsb3QoJ2xvZ2ljYWxfc2xvdDEnLCdwZ291dHB1
dCcpOw0KIHBnX2NyZWF0ZV9sb2dpY2FsX3JlcGxpY2F0aW9uX3Nsb3QgDQotLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAobG9naWNhbF9zbG90MSwwLzQ5NzZEOUQ4KQ0KKDEg
cm93KQ0KDQpsb2dpY2FsX3NyYz0jIGNyZWF0ZSBwdWJsaWNhdGlvbiBwdWJfdHdvIGZvciB0YWJs
ZSB0YWIxLCB0YWIyOw0KQ1JFQVRFIFBVQkxJQ0FUSU9ODQpsb2dpY2FsX3NyYz0jIFxjIGxvZ2lj
YWxfZGVzdA0KWW91IGFyZSBub3cgY29ubmVjdGVkIHRvIGRhdGFiYXNlICJsb2dpY2FsX2Rlc3Qi
IGFzIHVzZXIgInBvc3RncmVzIi4NCmxvZ2ljYWxfZGVzdD0jIGNyZWF0ZSB0YWJsZSB0YWIxKGlk
IGludCBwcmltYXJ5IGtleSxpbmZvIHZhcmNoYXIpOw0KQ1JFQVRFIFRBQkxFDQpsb2dpY2FsX2Rl
c3Q9IyBjcmVhdGUgdGFibGUgdGFiMihpZCBpbnQgcHJpbWFyeSBrZXksaW5mbzEgdmFyY2hhcixp
bmZvMiB2YXJjaGFyKTsNCkNSRUFURSBUQUJMRQ0KbG9naWNhbF9kZXN0PSMgY3JlYXRlIHN1YnNj
cmlwdGlvbiBzdWJfdHdvIA0KbG9naWNhbF9kZXN0LSMgIGNvbm5lY3Rpb24gJ2hvc3RhZGRyPTEy
Ny4wLjAuMSBwb3J0PTE1MDEgdXNlcj1wb3N0Z3JlcyBkYm5hbWU9bG9naWNhbF9zcmMnIA0KbG9n
aWNhbF9kZXN0LSMgIHB1YmxpY2F0aW9uIHB1Yl90d28gd2l0aChjcmVhdGVfc2xvdD0nZmFsc2Un
LHNsb3RfbmFtZT0nbG9naWNhbF9zbG90MScpOw0KRVJST1I6ICBjb3VsZCBub3QgcmVjZWl2ZSBs
aXN0IG9mIHJlcGxpY2F0ZWQgdGFibGVzIGZyb20gdGhlIHB1Ymxpc2hlcjogRVJST1I6ICBjb2x1
bW4gdC5hdHRuYW1lcyBkb2VzIG5vdCBleGlzdA0KTElORSAyOiAsIHQuYXR0bmFtZXMNCiAgICAg
ICAgICBeDQoNCg0KDQoNCjM5NjkzNDQwNkBxcS5jb20NCiANCkZyb206IGhvdXpqLmZuc3RAZnVq
aXRzdS5jb20NCkRhdGU6IDIwMjItMDctMDEgMTI6MDkNClRvOiAzOTY5MzQ0MDZAcXEuY29tDQpD
QzogcGdzcWwtYnVncw0KU3ViamVjdDogUkU6IHBnMTUgYmV0YTIgYnVnOmNhdXNlIGJ5IGxvZ2Np
YWwgcmVwbGF0aW9uDQpPbiBGcmlkYXksIEp1bHkgMSwgMjAyMiAxMTozNSBBTSAzOTY5MzQ0MDZA
cXEuY29tIDwzOTY5MzQ0MDZAcXEuY29tPiAgd3JvdGU6DQo+IGhlbGxvLDoNCj4gDQo+ICAgaSBh
bSBqZXJvbWUgUGVuZywgIGZyb20gcGcxNSBiZXRhMiAgY2hhbmdlcyBzaW5jZSBiZXRhIDEgLCBp
IHRlc3QgdGhpcyBpdGVtIGFuZCBmb3VuZCBhIGVycm9yOg0KPiANCj4gPyBwZ19wdWJsaWNhdGlv
bl90YWJsZXMgbm93IHByb3ZpZGVzIGluZm9ybWF0aW9uIG9uIGNvbHVtbiBsaXN0cyBhbmQgcm93
IGZpbHRlcnMuDQo+IA0KPiBcYyBsb2dpY2FsX3NyYw0KPiBjcmVhdGUgdGFibGUgdGFiMShpZCBp
bnQgcHJpbWFyeSBrZXksaW5mbyB2YXJjaGFyKTsNCj4gY3JlYXRlIHRhYmxlIHRhYjIoaWQgaW50
IHByaW1hcnkga2V5LGluZm8xIHZhcmNoYXIsaW5mbzIgdmFyY2hhcik7DQo+IHNlbGVjdCBwZ19j
cmVhdGVfbG9naWNhbF9yZXBsaWNhdGlvbl9zbG90KCdsb2dpY2FsX3Nsb3QxJywncGdvdXRwdXQn
KTsNCj4gY3JlYXRlIHB1YmxpY2F0aW9uIHB1Yl90d28gZm9yIHRhYmxlIHRhYjEsIHRhYjI7DQo+
IA0KPiBcYyBsb2dpY2FsX2Rlc3QNCj4gY3JlYXRlIHRhYmxlIHRhYjEoaWQgaW50IHByaW1hcnkg
a2V5LGluZm8gdmFyY2hhcik7DQo+IGNyZWF0ZSB0YWJsZSB0YWIyKGlkIGludCBwcmltYXJ5IGtl
eSxpbmZvMSB2YXJjaGFyLGluZm8yIHZhcmNoYXIpOw0KPiBjcmVhdGUgc3Vic2NyaXB0aW9uIHN1
Yl90d28gDQo+ICBjb25uZWN0aW9uICdob3N0YWRkcj0xMjcuMC4wLjEgcG9ydD0xNTAxIHVzZXI9
cG9zdGdyZXMgZGJuYW1lPWxvZ2ljYWxfc3JjJyANCj4gIHB1YmxpY2F0aW9uIHB1Yl90d28gd2l0
aChjcmVhdGVfc2xvdD0nZmFsc2UnLHNsb3RfbmFtZT0nbG9naWNhbF9zbG90MScpOw0KPiANCj4g
RVJST1I6ICBjb3VsZCBub3QgcmVjZWl2ZSBsaXN0IG9mIHJlcGxpY2F0ZWQgdGFibGVzIGZyb20g
dGhlIHB1Ymxpc2hlcjogRVJST1I6ICBjb2x1bW4gdC5hdHRuYW1lcyBkb2VzIG5vdCBleGlzdA0K
PiBMSU5FIDI6ICwgdC5hdHRuYW1lcw0KIA0KSGksDQogDQpJIHRyaWVkIHlvdXIgcmVwcm9kdWN0
aW9uIHN0ZXBzIGJ1dCBjYW5ub3QgZ2V0IHRoZSBzYW1lIGVycm9yLg0KIA0KQ2FuIHlvdSBwbGVh
c2UgcHJvdmlkZSBzb21lIG1vcmUgaW5mb3JtYXRpb24gYWJvdXQgdGhlIHZlcnNpb24NCm9mIHB1
Ymxpc2hlciBhbmQgc3Vic2NyaWJlciB5b3UgdXNlZCA/DQogDQpKdXN0IHRvIGNvbmZpcm0sIGRp
ZCB5b3UgdXNlIHRoZSBQRzE1IGJldGExIG9yIGVhcmxpZXIgUEcxNSB2ZXJzaW9uDQphcyB0aGUg
cHVibGlzaGVyIGFuZCB1c2UgUEcxNSBiZXRhMiBhcyB0aGUgc3Vic2NyaWJlciA/DQogDQpCZXN0
IHJlZ2FyZHMsDQpIb3UgemoNCg==

------=_001_NextPart727446812337_=----
Content-Type: text/html;
	charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charse=
t=3Diso-2022-jp"><style>body { line-height: 1.5; }blockquote { margin-top:=
 0px; margin-bottom: 0px; margin-left: 0.5em; }body { font-size: 14px; fon=
t-family: "Microsoft YaHei UI"; color: rgb(0, 0, 0); line-height: 1.5; }</=
style></head><body>=0A<div><span></span><div>$ /opt/pg15-beta2/bin/psql -p=
1502</div><div>psql (15beta2)</div><div>Type "help" for help.</div><div><b=
r></div><div>postgres=3D# drop database logical_src;</div><div>DROP DATABA=
SE</div><div>postgres=3D# drop database logical_dest ;</div><div>DROP DATA=
BASE</div><div>postgres=3D# select version();</div><div>&nbsp; &nbsp; &nbs=
p; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &=
nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp=
; &nbsp; version&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &n=
bsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</div><div>--------------=
--------------------------------------------------------------------------=
--------------------</div><div>&nbsp;PostgreSQL 15beta2 on x86_64-pc-linux=
-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit</div=
><div>(1 row)</div><div><br></div><div>postgres=3D# create database logica=
l_src;</div><div>CREATE DATABASE</div><div>postgres=3D# create database lo=
gical_dest;</div><div>CREATE DATABASE</div><div>postgres=3D# \c logical_sr=
c</div><div>You are now connected to database "logical_src" as user "postg=
res".</div><div>logical_src=3D# create table tab1(id int primary key,info =
varchar);</div><div>CREATE TABLE</div><div>logical_src=3D# create table ta=
b2(id int primary key,info1 varchar,info2 varchar);</div><div>CREATE TABLE=
</div><div>logical_src=3D# select pg_create_logical_replication_slot('logi=
cal_slot1','pgoutput');</div><div>&nbsp;pg_create_logical_replication_slot=
&nbsp;</div><div>------------------------------------</div><div>&nbsp;(log=
ical_slot1,0/4976D9D8)</div><div>(1 row)</div><div><br></div><div>logical_=
src=3D# create publication pub_two for table tab1, tab2;</div><div>CREATE =
PUBLICATION</div><div>logical_src=3D# \c logical_dest</div><div>You are no=
w connected to database "logical_dest" as user "postgres".</div><div>logic=
al_dest=3D# create table tab1(id int primary key,info varchar);</div><div>=
CREATE TABLE</div><div>logical_dest=3D# create table tab2(id int primary k=
ey,info1 varchar,info2 varchar);</div><div>CREATE TABLE</div><div>logical_=
dest=3D# create subscription sub_two&nbsp;</div><div>logical_dest-#&nbsp; =
connection 'hostaddr=3D127.0.0.1 port=3D1501 user=3Dpostgres dbname=3Dlogi=
cal_src'&nbsp;</div><div>logical_dest-#&nbsp; publication pub_two with(cre=
ate_slot=3D'false',slot_name=3D'logical_slot1');</div><div>ERROR:&nbsp; co=
uld not receive list of replicated tables from the publisher: ERROR:&nbsp;=
 column t.attnames does not exist</div><div>LINE 2: , t.attnames</div><div=
>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ^</div></div><div><br></div>=0A<div><b=
r></div><hr style=3D"width: 210px; height: 1px;" color=3D"#b5c4df" size=3D=
"1" align=3D"left">=0A<div><span><div style=3D"MARGIN: 10px; FONT-FAMILY: =
verdana; FONT-SIZE: 10pt"><div>396934406@qq.com</div></div></span></div>=
=0A<blockquote style=3D"margin-Top: 0px; margin-Bottom: 0px; margin-Left: =
0.5em; margin-Right: inherit"><div>&nbsp;</div><div style=3D"border:none;b=
order-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div style=3D"PAD=
DING-RIGHT: 8px; PADDING-LEFT: 8px; FONT-SIZE: 12px;FONT-FAMILY:tahoma;COL=
OR:#000000; BACKGROUND: #efefef; PADDING-BOTTOM: 8px; PADDING-TOP: 8px"><d=
iv><b>From:</b>&nbsp;<a href=3D"mailto:houzj.fnst@fujitsu.com">houzj.fnst@=
fujitsu.com</a></div><div><b>Date:</b>&nbsp;2022-07-01&nbsp;12:09</div><di=
v><b>To:</b>&nbsp;<a href=3D"mailto:396934406@qq.com">396934406@qq.com</a>=
</div><div><b>CC:</b>&nbsp;<a href=3D"mailto:pgsql-bugs@lists.postgresql.o=
rg">pgsql-bugs</a></div><div><b>Subject:</b>&nbsp;RE: pg15 beta2 bug:cause=
 by logcial replation</div></div></div><div><div>On Friday, July 1, 2022 1=
1:35 AM 396934406@qq.com &lt;396934406@qq.com&gt;&nbsp; wrote:</div>=0A<di=
v>&gt; hello,:</div>=0A<div>&gt; </div>=0A<div>&gt;&nbsp;&nbsp; i am jerom=
e Peng,&nbsp; from pg15 beta2&nbsp; changes since beta 1 , i test this ite=
m and found a error:</div>=0A<div>&gt; </div>=0A<div>&gt; ? pg_publication=
_tables now provides information on column lists and row filters.</div>=0A=
<div>&gt; </div>=0A<div>&gt; \c logical_src</div>=0A<div>&gt; create table=
 tab1(id int primary key,info varchar);</div>=0A<div>&gt; create table tab=
2(id int primary key,info1 varchar,info2 varchar);</div>=0A<div>&gt; selec=
t pg_create_logical_replication_slot('logical_slot1','pgoutput');</div>=0A=
<div>&gt; create publication pub_two for table tab1, tab2;</div>=0A<div>&g=
t; </div>=0A<div>&gt; \c logical_dest</div>=0A<div>&gt; create table tab1(=
id int primary key,info varchar);</div>=0A<div>&gt; create table tab2(id i=
nt primary key,info1 varchar,info2 varchar);</div>=0A<div>&gt; create subs=
cription sub_two </div>=0A<div>&gt;&nbsp; connection 'hostaddr=3D127.0.0.1=
 port=3D1501 user=3Dpostgres dbname=3Dlogical_src' </div>=0A<div>&gt;&nbsp=
; publication pub_two with(create_slot=3D'false',slot_name=3D'logical_slot=
1');</div>=0A<div>&gt; </div>=0A<div>&gt; ERROR:&nbsp; could not receive l=
ist of replicated tables from the publisher: ERROR:&nbsp; column t.attname=
s does not exist</div>=0A<div>&gt; LINE 2: , t.attnames</div>=0A<div>&nbsp=
;</div>=0A<div>Hi,</div>=0A<div>&nbsp;</div>=0A<div>I tried your reproduct=
ion steps but cannot get the same error.</div>=0A<div>&nbsp;</div>=0A<div>=
Can you please provide some more information about the version</div>=0A<di=
v>of publisher and subscriber you used ?</div>=0A<div>&nbsp;</div>=0A<div>=
Just to confirm, did you use the PG15 beta1 or earlier PG15 version</div>=
=0A<div>as the publisher and use PG15 beta2 as the subscriber ?</div>=0A<d=
iv>&nbsp;</div>=0A<div>Best regards,</div>=0A<div>Hou zj</div>=0A</div></b=
lockquote>=0A</body></html>
------=_001_NextPart727446812337_=------