Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iUoYU-0003fo-Ox for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Nov 2019 09:03:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iUoYT-0003wr-BF for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Nov 2019 09:03:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iUoYT-0003wk-3R for pgsql-bugs@lists.postgresql.org; Wed, 13 Nov 2019 09:03:13 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iUoYM-0003e6-3U for pgsql-bugs@lists.postgresql.org; Wed, 13 Nov 2019 09:03:12 +0000 Content-Type: multipart/mixed; boundary="===============0432004292040723875==" MIME-Version: 1.0 Subject: BUG #16110: Exporting data from SQL Server to PostgreSQL 12 using a linked server within SQL Server fails To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bart.hofland.2@gmail.com Reply-To: bart.hofland.2@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 13 Nov 2019 09:02:46 +0000 Message-ID: <16110-58018b81fc7ade4c@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0432004292040723875== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjExMApMb2dnZWQgYnk6ICAgICAgICAgIEJhcnQgSG9mbGFuZApFbWFp bCBhZGRyZXNzOiAgICAgIGJhcnQuaG9mbGFuZC4yQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDEyLjAKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwIChWZXJzaW9uIDEwLjAuMTgz NjIuNDQ5KQpEZXNjcmlwdGlvbjogICAgICAgIAoKKipUaGUgaXNzdWU6KioNCg0KRXhwb3J0aW5n IGRhdGEgZnJvbSBhIE1pY3Jvc29mdCBTUUwgU2VydmVyIGRhdGFiYXNlIHRhYmxlIHRvIGEgUG9z dGdyZVNRTCAxMgpkYXRhYmFzZSB0YWJsZSB1c2luZyBhIGxpbmtlZCBzZXJ2ZXIgdXNpbmcgdGhl IGxhdGVzdCBwc3Fsb2RiYyBkcml2ZXIgYW5kCnRoZSBPUEVOUVVFUlkgZnVuY3Rpb25hbGl0eSBp biBNaWNyb3NvZnQgU1FMIFNlcnZlciBmYWlscy4NCg0KUGVyZm9ybWluZyBleGFjdGx5IHRoZSBz YW1lIGV4cG9ydCB0byBhIFBvc3RncmVTUUwgMTEuNSBkYXRhYmFzZSB3b3JrcwpwZXJmZWN0bHkg ZmluZSwgaG93ZXZlci4NCg0KKipUaGUgZW52aXJvbm1lbnQ6KioNCg0KUGxhdGZvcm06IFdpbmRv d3MgMTAgNjQtYml0ICh2ZXJzaW9uIDEwLjAuMTgzNjIuNDQ5KQ0KcHNxbG9kYmM6IFZlcnNpb24g MTIuMC4wIChwc3Fsb2RiY18xMl8wMF8wMDAwLXg2NC56aXApDQpQb3N0Z3JlU1FMIDExLjU6ICJQ b3N0Z3JlU1FMIDExLjUsIGNvbXBpbGVkIGJ5IFZpc3VhbCBDKysgYnVpbGQgMTkxNCwKNjQtYml0 Ig0KUG9zdGdyZVNRTCAxMi4wOiAiUG9zdGdyZVNRTCAxMi4wLCBjb21waWxlZCBieSBWaXN1YWwg QysrIGJ1aWxkIDE5MTQsCjY0LWJpdCINClBvc3RncmVTUUwgY2xpZW50OiBwZ0FkbWluIDQuMTQg KHNlcGFyYXRlbHkgaW5zdGFsbGVkKQ0KU1FMIFNlcnZlcjogU1FMIFNlcnZlciAyMDE5IERldmVs b3BlciBFZGl0aW9uDQpTUUwgU2VydmVyIGNsaWVudDogU1FMIFNlcnZlciBNYW5hZ2VtZW50IFN0 dWRpbyAxOC40DQoNCioqU3RlcHMgdG8gcmVwcm9kdWNlOioqDQoNCi0gSW5zdGFsbCBQb3N0Z3Jl U1FMIDExLjUgZm9yIFdpbmRvd3MgKHNlbGVjdGluZyBvbmx5IGNvbXBvbmVudHMgIlBvc3RncmVT UUwKU2VydmVyIiBhbmQgIkNvbW1hbmQgTGluZSBUb29scyIsIHVzaW5nIHBhc3N3b3JkICJzb21l dGhpbmciIGZvciB0aGUKcG9zdGdyZXMgbWFzdGVyIGxvZ2luLCB1c2luZyBwb3J0IDU0MzIgKGlu IG15IGNhc2UpLCBhbmQgdXNpbmcgdGhlIEMKbG9jYWxlKS4NCi0gSW5zdGFsbCBQb3N0Z3JlU1FM IDEyLjAgZm9yIFdpbmRvd3MgKHNlbGVjdGluZyBvbmx5IGNvbXBvbmVudHMgIlBvc3RncmVTUUwK U2VydmVyIiBhbmQgIkNvbW1hbmQgTGluZSBUb29scyIsIHVzaW5nIHBhc3N3b3JkICJzb21ldGhp bmciIGZvciB0aGUKcG9zdGdyZXMgbWFzdGVyIGxvZ2luLCB1c2luZyBwb3J0IDU0MzMgKGluIG15 IGNhc2UpLCBhbmQgdXNpbmcgdGhlIEMKbG9jYWxlKS4NCi0gSW5zdGFsbCBwc3Fsb2RiYyAodGhl IGxhdGVzdCA2NC1iaXQgcmVsZWFzZSBvZiBPY3RvYmVyIDIwMTkpLg0KLSBJbnN0YWxsIFNRTCBT ZXJ2ZXIgKHByZWZlcnJhYmx5IGEgRGV2ZWxvcGVyIEVkaXRpb24gb2YgdmVyc2lvbiAyMDE5LCBi dXQKb3RoZXIgcmVjZW50IHZlcnNpb25zL2VkaXRpb25zIG1pZ2h0IHdvcmsganVzdCBmaW5lIGFz IHdlbGwpLg0KLSBJbiBib3RoIFBvc3RncmVTUUwgc2VydmVycywgY3JlYXRlIGEgdGFyZ2V0IGRh dGFiYXNlIGNhbGxlZCAidGFyZ2V0X2RiIi4NCi0gSW5zdGFsbCBTUUwgY2xpZW50IHRvb2xzLCBs aWtlIHBnQWRtaW4gYW5kIFNRTCBTZXJ2ZXIgTWFuYWdlbWVudCBTdHVkaW8KKG9yIHlvdXIgb3du IGZhdm9yaXRlIGNsaWVudCB0b29scyB0aGF0IGVuYWJsZSB5b3UgdG8gbWFuYWdlIFNRTCBTZXJ2 ZXIgYW5kClBvc3RncmVTUUwgZGF0YWJhc2VzKS4NCi0gSW4gdGhlICJ0YXJnZXRfZGIiIGRhdGFi YXNlcyBpbiBib3RoIFBvc3RncmVTUUwgc2VydmVycywgY3JlYXRlIGFuIGVtcHR5CnRhcmdldCB0 YWJsZSAidGFyZ2V0X3RhYmxlIjoNCg0KYGBgDQpDUkVBVEUgVEFCTEUgInRhcmdldF90YWJsZSIg KCJ2YWx1ZSIgaW50IE5PVCBOVUxMKTsNCmBgYA0KDQotIEluIFNRTCBTZXJ2ZXIsIGNyZWF0ZSBh IGRhdGFiYXNlICJTb3VyY2VEQiIuDQotIEluIHRoZSAiU291cmNlREIiIGRhdGFiYXNlIGluIFNR TCBTZXJ2ZXIsIGNyZWF0ZSBhIHNvdXJjZSB0YWJsZQoiU291cmNlVGFibGUiLCB1c2luZyB0aGUg c2NyaXB0IGJlbG93Og0KDQpgYGANCkNSRUFURSBUQUJMRSBbU291cmNlREJdLi5bU291cmNlVGFi bGVdIChbVmFsdWVdIElOVCBOT1QgTlVMTCk7DQpJTlNFUlQgSU5UTyBbU291cmNlREJdLi5bU291 cmNlVGFibGVdIChbVmFsdWVdKSBWQUxVRVMgKDEpLCAoMiksICgzKTsNCmBgYA0KDQotIEluIFNR TCBTZXJ2ZXIsIGNyZWF0ZSBsaW5rZWQgc2VydmVycyB0YXJnZXRpbmcgdGhlICJ0YXJnZXRfZGIi IGRhdGFiYXNlcwppbiB0aGUgUG9zdGdyZVNRTCAxMS41IGFuZCAxMi4wIHNlcnZlcnMsIHVzaW5n IHRoZSBzY3JpcHRzIGJlbG93Og0KDQpgYGANCkVYRUNVVEUgc3BfYWRkbGlua2Vkc2VydmVyDQog IEBzZXJ2ZXIgPSBOJ3Bvc3RncmVzXzExX3RhcmdldCcsDQogIEBzcnZwcm9kdWN0ID0gTidQb3N0 Z3JlU1FMIFVuaWNvZGUnLA0KICBAcHJvdmlkZXIgPSBOJ01TREFTUUwnLA0KICBAcHJvdnN0ciA9 IE4nRHJpdmVyPXtQb3N0Z3JlU1FMClVuaWNvZGUoeDY0KX07U2VydmVyPTEyNy4wLjAuMTtQb3J0 PTU0MzI7RGF0YWJhc2U9dGFyZ2V0X2RiO1VzZXIKSWQ9cG9zdGdyZXM7UGFzc3dvcmQ9c29tZXRo aW5nO01heFZhcmNoYXJzaXplPS00O01heExvbmdWYXJjaGFyU2l6ZT0tNCc7DQoNCkVYRUNVVEUg c3Bfc2VydmVyb3B0aW9uDQogIEBzZXJ2ZXIgPSBOJ3Bvc3RncmVzXzExX3RhcmdldCcsDQogIEBv cHRuYW1lID0gTidycGMnLA0KICBAb3B0dmFsdWUgPSBOJ3RydWUnOw0KDQpFWEVDVVRFIHNwX3Nl cnZlcm9wdGlvbg0KICBAc2VydmVyID0gTidwb3N0Z3Jlc18xMV90YXJnZXQnLA0KICBAb3B0bmFt ZSA9IE4ncnBjIG91dCcsDQogIEBvcHR2YWx1ZSA9IE4ndHJ1ZSc7DQoNCkVYRUNVVEUgc3BfYWRk bGlua2Vkc3J2bG9naW4NCiAgQHJtdHNydm5hbWUgPSBOJ3Bvc3RncmVzXzExX3RhcmdldCcsDQog IEB1c2VzZWxmID0gTidmYWxzZScsDQogIEBybXR1c2VyID0gTidwb3N0Z3JlcycsDQogIEBybXRw YXNzd29yZCA9IE4nc29tZXRoaW5nJzsNCmBgYA0KDQpgYGANCkVYRUNVVEUgc3BfYWRkbGlua2Vk c2VydmVyDQogIEBzZXJ2ZXIgPSBOJ3Bvc3RncmVzXzEyX3RhcmdldCcsDQogIEBzcnZwcm9kdWN0 ID0gTidQb3N0Z3JlU1FMIFVuaWNvZGUnLA0KICBAcHJvdmlkZXIgPSBOJ01TREFTUUwnLA0KICBA cHJvdnN0ciA9IE4nRHJpdmVyPXtQb3N0Z3JlU1FMClVuaWNvZGUoeDY0KX07U2VydmVyPTEyNy4w LjAuMTtQb3J0PTU0MzM7RGF0YWJhc2U9dGFyZ2V0X2RiO1VzZXIKSWQ9cG9zdGdyZXM7UGFzc3dv cmQ9c29tZXRoaW5nO01heFZhcmNoYXJzaXplPS00O01heExvbmdWYXJjaGFyU2l6ZT0tNCc7DQoN CkVYRUNVVEUgc3Bfc2VydmVyb3B0aW9uDQogIEBzZXJ2ZXIgPSBOJ3Bvc3RncmVzXzEyX3Rhcmdl dCcsDQogIEBvcHRuYW1lID0gTidycGMnLA0KICBAb3B0dmFsdWUgPSBOJ3RydWUnOw0KDQpFWEVD VVRFIHNwX3NlcnZlcm9wdGlvbg0KICBAc2VydmVyID0gTidwb3N0Z3Jlc18xMl90YXJnZXQnLA0K ICBAb3B0bmFtZSA9IE4ncnBjIG91dCcsDQogIEBvcHR2YWx1ZSA9IE4ndHJ1ZSc7DQoNCkVYRUNV VEUgc3BfYWRkbGlua2Vkc3J2bG9naW4NCiAgQHJtdHNydm5hbWUgPSBOJ3Bvc3RncmVzXzEyX3Rh cmdldCcsDQogIEB1c2VzZWxmID0gTidmYWxzZScsDQogIEBybXR1c2VyID0gTidwb3N0Z3Jlcycs DQogIEBybXRwYXNzd29yZCA9IE4nc29tZXRoaW5nJzsNCmBgYA0KDQpOb3RlOiBZb3UgbWlnaHQg bmVlZCB0byB1cGRhdGUgdGhlIHBvcnQgbnVtYmVycyBpbiB0aGUgbGlua2VkIHNlcnZlcgpjb25u ZWN0aW9uIHN0cmluZ3MgdG8geW91ciBhY3R1YWwgcG9ydCBudW1iZXJzLg0KDQotIEluIFNRTCBT ZXJ2ZXIsIHZlcmlmeSB0aGF0IHRoZSBsaW5rZWQgc2VydmVycyBhcmUgd29ya2luZyBieSBzZWxl Y3RpbmcKZGF0YSBpbiB0aGUgUG9zdGdyZVNRTCB0YXJnZXQgdGFibGUsIHVzaW5nIHRoZXNlIHF1 ZXJpZXM6DQoNCmBgYA0KU0VMRUNUIFt2YWx1ZV0NCkZST00gT1BFTlFVRVJZKFtwb3N0Z3Jlc18x MV90YXJnZXRdLCAnU0VMRUNUICJ2YWx1ZSIgRlJPTQoidGFyZ2V0X3RhYmxlIicpOw0KYGBgDQoN CmBgYA0KU0VMRUNUIFt2YWx1ZV0NCkZST00gT1BFTlFVRVJZKFtwb3N0Z3Jlc18xMl90YXJnZXRd LCAnU0VMRUNUICJ2YWx1ZSIgRlJPTQoidGFyZ2V0X3RhYmxlIicpOw0KYGBgDQoNCi0gSW4gU1FM IFNlcnZlciwgZXhlY3V0ZSB0aGUgZm9sbG93aW5nIHF1ZXJpZXMgdG8gZXhwb3J0IGRhdGEgZnJv bSBTUUwKU2VydmVyIHRvIHRoZSBQb3N0Z3JlU1FMIHRhcmdldCBkYXRhYmFzZXM6DQoNCmBgYA0K SU5TRVJUIE9QRU5RVUVSWShbcG9zdGdyZXNfMTFfdGFyZ2V0XSwgJ1NFTEVDVCAidmFsdWUiIEZS T00KInRhcmdldF90YWJsZSInKQ0KU0VMRUNUIFtWYWx1ZV0gRlJPTSBbU291cmNlREJdLi5bU291 cmNlVGFibGVdOw0KYGBgDQoNCmBgYA0KSU5TRVJUIE9QRU5RVUVSWShbcG9zdGdyZXNfMTJfdGFy Z2V0XSwgJ1NFTEVDVCAidmFsdWUiIEZST00KInRhcmdldF90YWJsZSInKQ0KU0VMRUNUIFtWYWx1 ZV0gRlJPTSBbU291cmNlREJdLi5bU291cmNlVGFibGVdOw0KYGBgDQoNClRoZSBmaXJzdCBxdWVy eSB3aWxsIHN1Y2NlZWQuIEFuZCB3aGVuIGV4ZWN1dGluZyB0aGUgU0VMRUNUIHF1ZXJ5IGZyb20g dGhlCnByZXZpb3VzIHN0ZXAsIHRoZSBuZXcgZGF0YSBpbiB0aGUgUG9zdGdyZVNRTCB0YXJnZXQg dGFibGUgd2lsbCBiZSBzaG93bi4NCg0KVGhlIHNlY29uZCBxdWVyeSB3aWxsIGZhaWwgd2l0aCB0 aGUgZm9sbG93aW5nIGVycm9yIG1lc3NhZ2VzOg0KDQpgYGANCk1zZyA3Mzk5LCBMZXZlbCAxNiwg U3RhdGUgMSwgTGluZSAxDQpUaGUgT0xFIERCIHByb3ZpZGVyICJNU0RBU1FMIiBmb3IgbGlua2Vk IHNlcnZlciAicG9zdGdyZXNfMTJfdGFyZ2V0IgpyZXBvcnRlZCBhbiBlcnJvci4gVGhlIHByb3Zp ZGVyIGRpZCBub3QgZ2l2ZSBhbnkgaW5mb3JtYXRpb24gYWJvdXQgdGhlCmVycm9yLg0KTXNnIDcz MjAsIExldmVsIDE2LCBTdGF0ZSAyLCBMaW5lIDENCkNhbm5vdCBleGVjdXRlIHRoZSBxdWVyeSAi U0VMRUNUICJ2YWx1ZSIgRlJPTSAidGFyZ2V0X3RhYmxlIiIgYWdhaW5zdCBPTEUgREIKcHJvdmlk ZXIgIk1TREFTUUwiIGZvciBsaW5rZWQgc2VydmVyICJwb3N0Z3Jlc18xMl90YXJnZXQiLg0KYGBg Cgo= --===============0432004292040723875==--