Thanks Tom. These tables with this issue are related to Arcgis. I cannot modify existing tables by adding primary keys if it doesn't already have one.
Will have to exclude these tables from replication it appears.
Will have to exclude these tables from replication it appears.
On April 17, 2025 11:05:25 AM EDT, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Mike L <giantmetfan@xxxxxxxxxxx> writes:Should logical replication fail due to a column of type 'xml' in a table
in a publication?
Well, as you note, there's no equality operator for type xml.
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). 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.
regards, tom lane
Mike L
