Re: Object identifier types in logical replication binary mode

> I tested with both 'binary = true' and 'binary = false' option while
> creating a subscription. For me replication is working fine and I am
> not getting any errors in both the cases.
> I have also attached the test script.

I modified your test script to demonstrate the problem.

I created another table before the tested one to make sure oids are
different between the nodes, and used the user-created table in the
test.

I also had to change the subscriber data type to text to get "invalid
byte sequence" error. Still the same script works without the error
with (binary = false).

My analysis on the original post was wrong. The subscriber handles it
as an oid. Though, it's still not clear to me this is a desirable
behaviour for the users, because oid's of the objects differ.