Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sog1k-00CyLO-2u for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Sep 2024 09:22:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sog1j-002Z5K-Cf for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Sep 2024 09:22:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1soeGK-000Ibz-9x for pgsql-bugs@lists.postgresql.org; Thu, 12 Sep 2024 07:29:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1soeGH-000lQp-I1 for pgsql-bugs@lists.postgresql.org; Thu, 12 Sep 2024 07:29:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=VjELeZ26V3lDIdaQYjE0EKv8iVnChlUZrPEYRUN1wCs=; b=FY4nMl/BOULIc3C0QMjILu+X1a ZQNsO9+KC0pdIFy5EiHJ4pW3OAg987IIXRSH3lNVqZGgcPr39d2/ViPIZlqprBfqlLlctY6M7zywF ejQgHv8zWRVMU71uORSVNvNBf7IdGemKgSYRU6R72WExDeydwFjgkmA5dZ4fUBsGECOU3T+/sy2y0 HryGAvl8ebzYFgQV/2vKjTnsnOoEPxrCL4M8tYNxwPp5ALKrZ57tQS+f0SArRfH+Mevh8pRJNbNXq yYMXJVW0ovjcvouI1J1eQaEPvtouNx4e8efI3rhLXTJwfzfiuxfpZ/kCltpy7qJue1xxo3+Rpd+Om e8Qf+8hg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1soeGF-002cvY-V1 for pgsql-bugs@lists.postgresql.org; Thu, 12 Sep 2024 07:29:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1soeGE-005l06-Qi for pgsql-bugs@lists.postgresql.org; Thu, 12 Sep 2024 07:29:02 +0000 Content-Type: multipart/mixed; boundary="===============5377310588364726844==" MIME-Version: 1.0 Subject: BUG #18613: Incorrect output for foreign tables with NOT NULL constraints To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: m.michkov@arenadata.io Reply-To: m.michkov@arenadata.io, pgsql-bugs@lists.postgresql.org Date: Thu, 12 Sep 2024 07:28:32 +0000 Message-ID: <18613-08a94418126ae1a0@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5377310588364726844== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODYxMwpMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIE1pY2hrb3YKRW1h aWwgYWRkcmVzczogICAgICBtLm1pY2hrb3ZAYXJlbmFkYXRhLmlvClBvc3RncmVTUUwgdmVyc2lv bjogMTdyYzEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCklmIGZvcmVpZ24gdGFibGUgZGF0YSBjb250YWlucyBudWxscyB3aGlsZSB0aGUgdGFi bGUgZGVmaW5pdGlvbiBzcGVjaWZpZXMgYQpOT1QgTlVMTCBjb25zdHJhaW50LCBzb21lIHF1ZXJp ZXMgcmV0dXJuIHdyb25nIG91dHB1dHMuIEZvciBleGFtcGxlLCBmb3IKZmlsZSAvZGF0YS5jc3Yg d2l0aCB0aGUgZm9sbG93aW5nIGNvbnRlbnRzOg0KDQoxLDEwDQoyLDIwDQozLG51bGwNCjQsNDAN Cg0KVGhlIGZvbGxvd2luZyBxdWVyaWVzIHJldHVybnMgaW5jb3JyZWN0IHJlc3VsdDoNCg0KQ1JF QVRFIEVYVEVOU0lPTiBmaWxlX2ZkdzsNCkNSRUFURSBTRVJWRVIgZmlsZV9zZXJ2ZXIgRk9SRUlH TiBEQVRBIFdSQVBQRVIgZmlsZV9mZHc7DQpDUkVBVEUgRk9SRUlHTiBUQUJMRSB0KGEgaW50LCBi IGludCBub3QgbnVsbCkgU0VSVkVSIGZpbGVfc2VydmVyIE9QVElPTlMgKApmaWxlbmFtZSAnL2Rh dGEuY3N2JywgZm9ybWF0ICdjc3YnLCBudWxsICdudWxsJyApOw0KU0VMRUNUICogRlJPTSB0IFdI RVJFIGIgSVMgTk9UIE5VTEw7DQpTRUxFQ1QgKiBGUk9NIHQgV0hFUkUgYiBJUyBOVUxMOw0KDQpP dXRwdXRzOg0KDQpwb3N0Z3Jlcz0jIFNFTEVDVCAqIEZST00gdCBXSEVSRSBiIElTIE5PVCBOVUxM Ow0KIGEgfCBiICANCi0tLSstLS0tDQogMSB8IDEwDQogMiB8IDIwDQogMyB8ICAgDQogNCB8IDQw DQooNCByb3dzKQ0KDQpwb3N0Z3Jlcz0jIFNFTEVDVCAqIEZST00gdCBXSEVSRSBiIElTIE5VTEw7 DQogYSB8IGIgDQotLS0rLS0tDQooMCByb3dzKQ0KDQpFeHBlY3RlZCBhbiBlcnJvciAoc3RhdGlu ZyB0aGF0IHRoZSBmb3JlaWduIHRhYmxlIGNvbnRhaW5zIE5VTExzKSBvciB0aGUKZm9sbG93aW5n IG91dHB1dDoNCg0KcG9zdGdyZXM9IyBTRUxFQ1QgKiBGUk9NIHQgV0hFUkUgYiBJUyBOT1QgTlVM TDsNCiBhIHwgYiAgDQotLS0rLS0tLQ0KIDEgfCAxMA0KIDIgfCAyMA0KIDQgfCA0MA0KKDMgcm93 cykNCg0KcG9zdGdyZXM9IyBTRUxFQ1QgKiBGUk9NIHQgV0hFUkUgYiBJUyBOVUxMOw0KIGEgfCBi IA0KLS0tKy0tLQ0KIDMgfCAgDQooMSByb3cpDQoNClRoZSBidWcgYXBwZWFyZWQgYWZ0ZXIgdGhp cyBwYXRjaDoKaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9FMXJTOTJkLTAw MmdiTy1FSiU0MGdlbXVsb24ucG9zdGdyZXNxbC5vcmcNClRoZSBwYXRjaCBhZGRlZCBvcHRpbWl6 YXRpb25zIGZvciBJUyBbTk9UXSBOVUxMIGNoZWNrcyBmb3IgY29sdW1ucyB3aXRoIE5PVApOVUxM LCBob3dldmVyIGl0IGlzIHBvc3NpYmxlIGZvciBmb3JlaWduIHRhYmxlcyB0byBjb250YWluIG51 bGxzIGV2ZW4gaW4KdGhhdCBjYXNlLiBBIHBvc3NpYmxlIHNvbHV0aW9ucyBjb3VsZCBiZSByZXZl cnRpbmcgdGhhdCBwYXRjaCwgb3IgYWRkaW5nIGEKc3BlY2lhbCBjYXNlIGZvciBmb3JlaWduIHRh Ymxlcywgb3IgaWdub3JpbmcgTk9UIE5VTEwgY29uc3RyYWludHMgb24gZm9yZWlnbgp0YWJsZXMg aW4gZ2VuZXJhbCAoYmVjYXVzZSB3ZSBjYW5ub3QgY2hlY2sgdGhleSBhcmUgdmFsaWQpLgoK --===============5377310588364726844==--