Andres Freund <and...@anarazel.de> writes: > There's also send/receive functions that do not work across systems, > unfortunately :(. In particular record and array send functions embed > type oids and their receive functions verify that they match the local > system. Which basically means that if there's any difference in oid > assignment order between two systems that they will not allow to > send/recv such data between them :(.
It's not a problem particularly for built-in types, but I agree there's an issue for extension types. > I've several times suggested that we should remove those type checks in > recv, as they afaict don't provide any actual value. But unfortunately > there hasn't been much response to that. See e.g. > https://postgr.es/m/20160426001713.hbqdiwvf4mkzkg55%40alap3.anarazel.de Maybe we could compromise by omitting the check if both OIDs are outside the built-in range? regards, tom lane
