Date: Thu, 17 Apr 2025 11:52:02 -0400
From: Mike L <giantmetfan@comcast.net>
To: pgsql-admin@lists.postgresql.org
Subject: Re: logical replication issue
User-Agent: Thunderbird for Android
In-Reply-To: <2200808.1744902325@sss.pgh.pa.us>
References: <e31c971c-877a-4d2d-b90f-a3a5cb0affc7@comcast.net>
 <2200808.1744902325@sss.pgh.pa.us>
Message-ID: <D8690293-22E3-4656-8C54-78433EC4A996@comcast.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary=----G8BW5SSB955ZQBK5VRCEFMCCZLQUX4
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/D8690293-22E3-4656-8C54-78433EC4A996%40comcast.net>
Precedence: bulk

------G8BW5SSB955ZQBK5VRCEFMCCZLQUX4
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

Thanks Tom=2E These tables with this issue are related to Arcgis=2E I canno=
t modify existing tables by adding primary keys if it doesn't already have =
one=2E
Will have to exclude these tables from replication it appears=2E=20

On April 17, 2025 11:05:25 AM EDT, Tom Lane <tgl@sss=2Epgh=2Epa=2Eus> wrot=
e:
>Mike L <giantmetfan@comcast=2Enet> writes:
>> Should logical replication fail due to a column of type 'xml' in a tabl=
e=20
>> in a publication?
>
>Well, as you note, there's no equality operator for type xml=2E
>
>Looking at the replication code, it looks like you might be able
>to dodge the error if the replicated-to table has a primary key
>(which'd necessarily not involve the xml column)=2E  Without a PK,
>it will do full-row equality checks to determine tuple matches,
>and that's where it falls down trying to compare the xml column=2E
>
>			regards, tom lane
>
>

Mike L
------G8BW5SSB955ZQBK5VRCEFMCCZLQUX4
Content-Type: text/html;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div dir=3D"auto">Thanks Tom=2E These tables with =
this issue are related to Arcgis=2E I cannot modify existing tables by addi=
ng primary keys if it doesn't already have one=2E<br>Will have to exclude t=
hese tables from replication it appears=2E </div><br><br><div class=3D"gmai=
l_quote"><div dir=3D"auto">On April 17, 2025 11:05:25 AM EDT, Tom Lane &lt;=
tgl@sss=2Epgh=2Epa=2Eus&gt; wrote:</div><blockquote class=3D"gmail_quote" s=
tyle=3D"margin: 0pt 0pt 0pt 0=2E8ex; border-left: 1px solid rgb(204, 204, 2=
04); padding-left: 1ex;">
<pre class=3D"k9mail"><div dir=3D"auto">Mike L &lt;giantmetfan@comcast=2En=
et&gt; writes:<br></div><blockquote class=3D"gmail_quote" style=3D"margin: =
0pt 0pt 1ex 0=2E8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"><d=
iv dir=3D"auto">Should logical replication fail due to a column of type 'xm=
l' in a table <br>in a publication?<br></div></blockquote><div dir=3D"auto"=
><br>Well, as you note, there's no equality operator for type xml=2E<br><br=
>Looking at the replication code, it looks like you might be able<br>to dod=
ge the error if the replicated-to table has a primary key<br>(which'd neces=
sarily not involve the xml column)=2E  Without a PK,<br>it will do full-row=
 equality checks to determine tuple matches,<br>and that's where it falls d=
own trying to compare the xml column=2E<br><br>			regards, tom lane<br><br>=
<br></div></pre></blockquote></div><div dir=3D"auto">Mike L</div></body></h=
tml>
------G8BW5SSB955ZQBK5VRCEFMCCZLQUX4--