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 1kBID2-0002RT-TX for pgsql-bugs@arkaria.postgresql.org; Thu, 27 Aug 2020 13:44:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kBID1-0001lf-RN for pgsql-bugs@arkaria.postgresql.org; Thu, 27 Aug 2020 13:44:55 +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 1kBI2Y-0002oC-Oh for pgsql-bugs@lists.postgresql.org; Thu, 27 Aug 2020 13:34:06 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kBI2U-0006Rj-Vc for pgsql-bugs@lists.postgresql.org; Thu, 27 Aug 2020 13:34:06 +0000 Content-Type: multipart/mixed; boundary="===============8098633536879469605==" MIME-Version: 1.0 Subject: BUG #16597: postgres_fdw: types in statically defined FOREIGN TABLE are not honored To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: filip@prochazka.su Reply-To: filip@prochazka.su, pgsql-bugs@lists.postgresql.org Date: Thu, 27 Aug 2020 13:33:12 +0000 Message-ID: <16597-637b24e3a224fc14@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8098633536879469605== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjU5NwpMb2dnZWQgYnk6ICAgICAgICAgIEZpbGlwIFByb2Now6F6a2EK RW1haWwgYWRkcmVzczogICAgICBmaWxpcEBwcm9jaGF6a2Euc3UKUG9zdGdyZVNRTCB2ZXJzaW9u OiAxMS45Ck9wZXJhdGluZyBzeXN0ZW06ICAgQWxwaW5lIExpbnV4IHYzLjEyIChpbiBEb2NrZXIp CkRlc2NyaXB0aW9uOiAgICAgICAgCgpJJ3ZlIGNyZWF0ZWQgYSBzZXJ2ZXIgYW5kIHVzZXINCg0K Q1JFQVRFIFNFUlZFUiB0ZXN0IEZPUkVJR04gREFUQSBXUkFQUEVSIHBvc3RncmVzX2ZkdyAuLi47 DQpDUkVBVEUgVVNFUiBNQVBQSU5HIEZPUiB1c2VyIFNFUlZFUiB0ZXN0IC4uLjsNCg0KYW5kIHNv bWUgZm9yZWlnbiB0YWJsZXMgYW5kIEknbSBhYmxlIHRvIGNvbm5lY3QgYW5kIHF1ZXJ5IHRoZSBm b3JlaWduIGRiLiBTbwpmYXIgc28gZ29vZC4NCg0KVGhlIHByb2JsZW0gaXMsIHRoYXQgdGhlIHJl bW90ZSBzZXJ2ZXIgdXNlcyBlbnVtcy4gSSd2ZSByZWFkIHRoZSBlbWFpbHMKd2hlcmUgcGVvcGxl IGFyZSBkaXNjdXNzaW5nIHRoYXQgdGhleSBkb24ndCB3YW50IHRoZSBJTVBPUlQgRk9SRUlHTiBT Q0hFTUEKdG8gaW1wb3J0IGFsc28gY3VzdG9tIHR5cGVzIGxpa2UgZW51bXMuIFRoaXMgaXMgYSBw cm9ibGVtIGZvciBtZSwgYnV0IEkKZmlndXJlZCB0aGF0IHNpbXBseSBkZWNsYXJpbmcgdGhlIHRh YmxlcyB3aXRoIHRoZSBlbnVtIGNvbHVtbnMgYXMgdGV4dAppbnN0ZWFkIG9mIHRoZSBvcmlnaW5h bCBlbnVtIHR5cGVzIGFsc28gd29ya3MgYW5kIGFsbG93cyBtZSB0byBxdWVyeSB0aGUKdGFibGVz Lg0KDQpDUkVBVEUgRk9SRUlHTiBUQUJMRSBjel9zYWxlcyAoDQogICAgbW9udGggZGF0ZSwNCiAg ICB0eXBlX29mX2N1c3RvbWVyIHRleHQsDQogICAgc29sZF91bml0c190b3RhbCBiaWdpbnQsDQog ICAgc29sZF9wcmljZV90b3RhbCBkb3VibGUgcHJlY2lzaW9uDQopIFNFUlZFUiBwaWNrbGVfamFy IE9QVElPTlMgKFNDSEVNQV9OQU1FICdjeicsIFRBQkxFX05BTUUgJ3NhbGVzJywgdXBkYXRhYmxl CidmYWxzZScpOw0KDQpOb3cgd2hhdCBJIGRpZG4ndCBleHBlY3QgaXMgdGhhdCB3aGVuIHlvdSBh ZGQgYSBXSEVSRSBvciB0cnkgdG8gY29tcGFyZSB0aGUKZW51bSBjb2x1bW5zLCB0aGUgcXVlcnkg aXMgc2VudCBhcyBpcyB0byB0aGUgcmVtb3RlIHNlcnZlciBhbmQgZXhlY3V0ZWQKdGhlcmUgKEkn bSBndWVzc2luZyBoZXJlKSwgd2hpY2ggbWVhbnMgaXQgaWdub3JlcyB0aGUgdHlwZXMgSSd2ZSBk ZWZpbmVkCmxvY2FsbHkuDQoNClNFTEVDVCAqIEZST00gY3pfc2FsZXMgV0hFUkUgdHlwZV9vZl9j dXN0b21lciBJTiAoJ0RPQ1RPUicpOw0KDQpbNDI4ODNdIEVSUk9SOiBvcGVyYXRvciBkb2VzIG5v dCBleGlzdDogY3ouZW51bV90eXBlX29mX2N1c3RvbWVyID0gdGV4dA0KSGludDogTm8gb3BlcmF0 b3IgbWF0Y2hlcyB0aGUgZ2l2ZW4gbmFtZSBhbmQgYXJndW1lbnQgdHlwZShzKS4gWW91IG1pZ2h0 Cm5lZWQgdG8gYWRkIGV4cGxpY2l0IHR5cGUgY2FzdHMuDQpXaGVyZTogcmVtb3RlIFNRTCBjb21t YW5kOiBFWFBMQUlOIFNFTEVDVCAqIEZST00gY3ouc2FsZXMgV0hFUkUKKCh0eXBlX29mX2N1c3Rv bWVyID0gJ0RPQ1RPUic6OnRleHQpKQ0KDQpCdXQgaWYgSSBhZGQgYW4gZXhwbGljaXQgY2FzdCwg aXQgd29ya3MNCg0KU0VMRUNUICogRlJPTSBjel9zYWxlcyBXSEVSRSBDQVNUKHR5cGVfb2ZfY3Vz dG9tZXIgQVMgVEVYVCkgSU4gKCdET0NUT1InKTsNCg0KQnV0IHRoaXMgaXMgdmVyeSB1Z2x5IGJl Y2F1c2UgSSd2ZSBhbHJlYWR5IGRlY2xhcmVkIHRoZSBjb2x1bW4gYXMgVEVYVCBpbgp0aGUgc2No ZW1hIGFuZCBub3cgSSdtIGNhc3RpbmcgYSBURVhUIHRvIFRFWFQuIEkgd291bGQgZXhwZWN0IHRo YXQgdGhlCnBvc3RncmVzX2ZkdyBhZGRzIHRoZSB0eXBlIGNhc3RzIHRvIHRoZSBxdWVyaWVzIGZv ciBtZS4NCg0KVGhhbmsgeW91IGZvciBjb25zaWRlcmluZyB0aGlzIGJ1Zy9mZWF0dXJlDQoNClAu Uy46IHRoaXMgaXMgbXkgZmlyc3QgdGltZSByZXBvcnRpbmcgc29tZXRoaW5nIHRvIFBvc3RncmVz LCBzb3JyeSBpZiB0aGlzCmlzIHRoZSB3cm9uZyBtYWlsaW5nIGxpc3QgZm9yIHN1Y2ggcmVwb3J0 LgoK --===============8098633536879469605==--