Object identifier types in logical replication binary mode

From: Emre Hasegeli <emre(at)hasegeli(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Object identifier types in logical replication binary mode
Date: 2024-11-14 15:51:51
Message-ID: CAE2gYzytvWLKdvb_mGm9Eg1Edo1R=EqEdEpvBqALEHjcZpG8Gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I encountered a problem with logical replication.

The object identifier types, regclass, regproc, regtype, etc. are
transferred as an oid in the binary mode. However, the subscriber
expects them as text which makes sense because it cannot do anything
with the oids. I am getting "invalid byte sequence for encoding
"UTF8": 0x00" when I try this.

I think the publisher should not transfer these in binary just like
the data types from extensions. Any opinions?

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2024-11-14 15:53:01 Re: Potential ABI breakage in upcoming minor releases
Previous Message Ants Aasma 2024-11-14 15:23:48 Re: Potential ABI breakage in upcoming minor releases