Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jiDsy-0002CA-15 for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Jun 2020 09:16:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jiDsw-0008Kj-ET for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Jun 2020 09:16:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jiDEK-00023n-KT for pgsql-bugs@lists.postgresql.org; Mon, 08 Jun 2020 08:34:04 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jiDEI-00049E-NZ for pgsql-bugs@lists.postgresql.org; Mon, 08 Jun 2020 08:34:04 +0000 Content-Type: multipart/mixed; boundary="===============4313375691092503836==" MIME-Version: 1.0 Subject: BUG #16485: array_recv causes binary COPY to not work between postgres instances with arrays of custom types To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jelte.fennema@microsoft.com Reply-To: jelte.fennema@microsoft.com, pgsql-bugs@lists.postgresql.org Date: Mon, 08 Jun 2020 08:33:42 +0000 Message-ID: <16485-f7b2dddca52ef2ae@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4313375691092503836== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQ4NQpMb2dnZWQgYnk6ICAgICAgICAgIEplbHRlIEZlbm5lbWEKRW1h aWwgYWRkcmVzczogICAgICBqZWx0ZS5mZW5uZW1hQG1pY3Jvc29mdC5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDE4LjA0CkRlc2NyaXB0aW9u OiAgICAgICAgCgpDT1BZIGluIGJpbmFyeSBmb3JtYXQgc2hvdWxkLCBiYXNlZCBvbiB0aGUgZG9j dW1lbnRhdGlvbiwgd29yayBiZXR3ZWVuCmRpZmZlcmVudCBpbnN0YW5jZXMgb2YgdGhlIHNhbWUg UG9zdGdyZXMgc2VydmVyLiBUaGlzIGlzIG5vdCB0aGUgY2FzZSB3aGVuCmNvcHlpbmcgYXJyYXlz IG9mIGN1c3RvbSB0eXBlcy4gDQoNClN0ZXBzIHRvIHJlcHJvZHVjZToNCg0KQ1JFQVRFIFRZUEUg Y29tcG9zaXRlX3R5cGUgQVMgKA0KICAgIGkgaW50ZWdlciwNCiAgICBpMiBpbnRlZ2VyDQopOw0K DQpDUkVBVEUgVEFCTEUgY29tcG9zaXRlX3R5cGVfdGFibGUNCigNCgljb2wgY29tcG9zaXRlX3R5 cGVbXQ0KKTsNCklOU0VSVCBJTlRPIGNvbXBvc2l0ZV90eXBlX3RhYmxlIFZBTFVFUyAgKEFSUkFZ WycoMSwKMiknOjpjb21wb3NpdGVfdHlwZV0pOw0KXGNvcHkgY29tcG9zaXRlX3R5cGVfdGFibGUg dG8gZHVtcC5yYXcgQklOQVJZOw0KDQpkcm9wIHR5cGUgY29tcG9zaXRlX3R5cGUgY2FzY2FkZTsN Cg0KZHJvcCB0YWJsZSBjb21wb3NpdGVfdHlwZV90YWJsZTsNCi0tIHNhbWUgdHlwZSwgYnV0IHdp dGggZGlmZmVyZW50IE9JRCAoaW1pdGF0aW5nIGRpZmZlcmVudCBwb3N0Z3JlcwpkYXRhYmFzZSkN CkNSRUFURSBUWVBFIGNvbXBvc2l0ZV90eXBlIEFTICgNCiAgICBpIGludGVnZXIsDQogICAgaTIg aW50ZWdlcg0KKTsNCg0KQ1JFQVRFIFRBQkxFIGNvbXBvc2l0ZV90eXBlX3RhYmxlDQooDQoJY29s IGNvbXBvc2l0ZV90eXBlW10NCik7DQpcY29weSBjb21wb3NpdGVfdHlwZV90YWJsZSBmcm9tIGR1 bXAucmF3IEJJTkFSWTsNCi0tIEVSUk9SOiAgNDI4MDQ6IHdyb25nIGVsZW1lbnQgdHlwZQ0KLS0g Q09OVEVYVDogIENPUFkgY29tcG9zaXRlX3R5cGVfdGFibGUsIGxpbmUgMSwgY29sdW1uIGNvbA0K LS0gTE9DQVRJT046ICBhcnJheV9yZWN2LCBhcnJheWZ1bmNzLmM6MTMxNg0KDQoNCg0KVGhpcyBw aWVjZSBvZiBjb2RlIHNlZW1zIHRvIGJlIHRoZSBpc3N1ZToKaHR0cHM6Ly9naXRodWIuY29tL3Bv c3RncmVzL3Bvc3RncmVzL2Jsb2IvZWM1ZDZmYzRhZThjNzUzOTFkOTk5OTNjZDAzMGE4NzMzNzMz NzQ3ZC9zcmMvYmFja2VuZC91dGlscy9hZHQvYXJyYXlmdW5jcy5jI0wxMzEyLUwxMzE4DQpMaWtl IHRoZSBjb21tZW50IChmcm9tIDE3IHllYXJzIGFnbykgbWVudGlvbnMsIEkgZG9uJ3QgdGhpbmsg dGhpcyBjaGVjayBpcwphY3R1YWxseSBuZWVkZWQuIEFuZCBpbiB0aGlzIGNhc2UgaXQncyBhY3R1 YWxseSBodXJ0cy4gU3RvcmluZyB0aGUgT0lEIGF0CmFsbCBhY3R1YWxseSBzZWVtcyB1bm5lY2Fz c2FyeSwgYnV0IGNoYW5naW5nIHRoYXQgZG9lc24ndCBzZWVtIHdvcnRoIHRoZQpiYWNrd2FyZHMg aW5jb21wYXRpYmlsaXR5IHRvIG1lLg0KQXMgc29tZSBleHRyYSBpbmZvcm1hdGlvbiB0aGlzIGJp bmFyeSBjb3B5IGlzIG5vdCB0aGUgaXNzdWUgSSdtIGZhY2luZwpteXNlbGYuIEluIG15IGNhc2Ug SSdtIHJ1bm5pbmcgaW50byB0aGlzLCB3aGlsZSB0cnlpbmcgdG8gbWFrZSBDaXR1cyB1c2UgdGhl CmJpbmFyeSBwcm90b2NvbCBiZXR3ZWVuIG5vZGVzIHRvIHNhdmUgZGF0YS4NCg0KVGhlIGZvbGxv d2luZyBjaGFuZ2Ugb24gdG9wIG9mIFJFTF8xMl9TVEFCTEUgZml4ZXMgdGhlIGlzc3VlIGZvciBt ZS4gSWYgdGhpcwppcyBjb25zaWRlcmVkIHRoZSByaWdodCBmaXgsIEknZCBhcHByZWNpYXRlIHNv bWUgaGVscCBnZXQgdGhpcyBpbiB0aHJvdWdoCnRoZSByaWdodCBwcm9jZWR1cmVzLiBJdCB3b3Vs ZCBiZSBncmVhdCBpZiB0aGlzIGNvdWxkIGJlIGZpeGVkIGluIGFsbApjdXJyZW50bHkgc3VwcG9y dGVkIHZlcnNpb25zIG9mIFBvc3RncmVzLg0KDQoNCmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC91 dGlscy9hZHQvYXJyYXlmdW5jcy5jCmIvc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2FycmF5ZnVuY3Mu Yw0KaW5kZXggOGZjZGY4MjkyMi4uODFhNjFmN2JjNyAxMDA2NDQNCi0tLSBhL3NyYy9iYWNrZW5k L3V0aWxzL2FkdC9hcnJheWZ1bmNzLmMNCisrKyBiL3NyYy9iYWNrZW5kL3V0aWxzL2FkdC9hcnJh eWZ1bmNzLmMNCkBAIC0xMjY3LDEwICsxMjY3LDkgQEAgRGF0dW0NCiBhcnJheV9yZWN2KFBHX0ZV TkNUSU9OX0FSR1MpDQogew0KIAlTdHJpbmdJbmZvCWJ1ZiA9IChTdHJpbmdJbmZvKSBQR19HRVRB UkdfUE9JTlRFUigwKTsNCi0JT2lkCQkJc3BlY19lbGVtZW50X3R5cGUgPSBQR19HRVRBUkdfT0lE KDEpOwkvKiB0eXBlIG9mIGFuIGFycmF5DQorCU9pZAkJCWVsZW1lbnRfdHlwZSA9IFBHX0dFVEFS R19PSUQoMSk7CS8qIHR5cGUgb2YgYW4gYXJyYXkNCiAJCQkJCQkJCQkJCQkJCSAqIGVsZW1lbnQg Ki8NCiAJaW50MzIJCXR5cG1vZCA9IFBHX0dFVEFSR19JTlQzMigyKTsJLyogdHlwbW9kIGZvciBh cnJheSBlbGVtZW50cyAqLw0KLQlPaWQJCQllbGVtZW50X3R5cGU7DQogCWludAkJCXR5cGxlbjsN CiAJYm9vbAkJdHlwYnl2YWw7DQogCWNoYXIJCXR5cGFsaWduOw0KQEAgLTEzMDcsMTQgKzEzMDYs MTIgQEAgYXJyYXlfcmVjdihQR19GVU5DVElPTl9BUkdTKQ0KIAkJCQkoZXJyY29kZShFUlJDT0RF X0lOVkFMSURfQklOQVJZX1JFUFJFU0VOVEFUSU9OKSwNCiAJCQkJIGVycm1zZygiaW52YWxpZCBh cnJheSBmbGFncyIpKSk7DQogDQotCWVsZW1lbnRfdHlwZSA9IHBxX2dldG1zZ2ludChidWYsIHNp emVvZihPaWQpKTsNCi0JaWYgKGVsZW1lbnRfdHlwZSAhPSBzcGVjX2VsZW1lbnRfdHlwZSkNCi0J ew0KLQkJLyogWFhYIENhbiB3ZSBhbGxvdyB0YWtpbmcgdGhlIGlucHV0IGVsZW1lbnQgdHlwZSBp biBhbnkgY2FzZXM/ICovDQotCQllcmVwb3J0KEVSUk9SLA0KLQkJCQkoZXJyY29kZShFUlJDT0RF X0RBVEFUWVBFX01JU01BVENIKSwNCi0JCQkJIGVycm1zZygid3JvbmcgZWxlbWVudCB0eXBlIikp KTsNCi0JfQ0KKwkvKg0KKwkgKiBpZ25vcmUgZWxlbWVudF90eXBlIHN0b3JlZCBpbiBiaW5hcnkg ZGF0YS4gV2UgYWxyZWFkeSBrbm93IHRoZSB0eXBlLg0KKwkgKiBUaGUgc3RvcmVkIHR5cGUgY2Fu IGFjdHVhbGx5IGJlIGRpZmZlcmVudCBmcm9tIHRoZSB0eXBlIGhlcmUsIGJlY2F1c2UNCisJICog T0lEcyBkbyBub3QgbmVjZXNzYXJpbHkgbWF0Y2ggYmV0d2VlbiBkaWZmZXJlbnQgaW5zdGFsbGF0 aW9ucy4NCisJICovDQorCXBxX2dldG1zZ2ludChidWYsIHNpemVvZihPaWQpKTsNCiANCiAJZm9y IChpID0gMDsgaSA8IG5kaW07IGkrKykNCiAJewoK --===============4313375691092503836==--