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 1v5LSY-005H7m-1Z for pgsql-bugs@arkaria.postgresql.org; Sun, 05 Oct 2025 09:55:18 +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 1v5LSW-002JZk-BS for pgsql-bugs@arkaria.postgresql.org; Sun, 05 Oct 2025 09:55:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v5HBE-001tGO-Lx for pgsql-bugs@lists.postgresql.org; Sun, 05 Oct 2025 05:21:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v5HBC-000Sdu-2x for pgsql-bugs@lists.postgresql.org; Sun, 05 Oct 2025 05:21:09 +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=wfhSx44XFR2Y7uSHp02ZUfnY0g7Qjqo7AufQlynH7Cc=; b=KP/nBRfoVezqJ1JWllpixGLvli u2vWA5Ee6g3fAiIZFQlF0rxL1/3PQxA6bKp3blyz4wQFAhTyOe9khCUa0t63O/dMVNVSd72amUH19 Mtp8z1thXBm/aj9QXhao22Rk1SkyyKOo5Y+IkanR6OeWjz+Ktp73saT5MCsF9SnXONwH7tr9tslnm pqmItZ0lKEnz1Y0bq/ovGkknVJCrXQlDEknOAN/mI2/pKksm+D3f/xz9lbLOOHAQpdnrwTSV2y0Bn fIEY5MNknGSoCiewp9AwquGrDCMyLAi8Xxbu70rQRV1yibxKy/SxMrnn1e+hsnvpJhzmP4Uzv53fB nsdqwTOg==; 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 1v5HBB-000KrT-0q for pgsql-bugs@lists.postgresql.org; Sun, 05 Oct 2025 05:21:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v5HB8-0010KB-1t for pgsql-bugs@lists.postgresql.org; Sun, 05 Oct 2025 05:21:02 +0000 Content-Type: multipart/mixed; boundary="===============0862882468368737977==" MIME-Version: 1.0 Subject: BUG #19074: pg_dump from v18 loses the NOT NULL flag in the inherited table field when dumping v17-databases To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andrewbille@gmail.com Reply-To: andrewbille@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 05 Oct 2025 05:20:21 +0000 Message-ID: <19074-ae2548458cf0195c@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 --===============0862882468368737977== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA3NApMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJldyBCaWxsZQpFbWFp bCBhZGRyZXNzOiAgICAgIGFuZHJld2JpbGxlQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE4LjAKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAgICAg ICAKCkhlbGxvLgoKSW4gMTcuNiwgd2UncmUgY3JlYXRpbmcgdGFibGVzOgoKQ1JFQVRFIFRBQkxF IHAgKGEgaW50ZWdlcik7CkNSRUFURSBUQUJMRSBjICgpIElOSEVSSVRTIChwKTsKQUxURVIgVEFC TEUgT05MWSBjIEFMVEVSIENPTFVNTiBhIFNFVCBOT1QgTlVMTDsKCjE3L2Jpbi9wZ19kdW1wIHRl c3QgcmV0dXJuczoKCi4uLi4KQ1JFQVRFIFRBQkxFIHB1YmxpYy5wICgKYSBpbnRlZ2VyCik7CgpB TFRFUiBUQUJMRSBwdWJsaWMucCBPV05FUiBUTyBhbmRyZXc7CgotLQotLSBOYW1lOiBjOyBUeXBl OiBUQUJMRTsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBhbmRyZXcKLS0KCkNSRUFURSBUQUJMRSBw dWJsaWMuYyAoCikKSU5IRVJJVFMgKHB1YmxpYy5wKTsKQUxURVIgVEFCTEUgT05MWSBwdWJsaWMu YyBBTFRFUiBDT0xVTU4gYSBTRVQgTk9UIE5VTEw7Ci4uLi4KCgpSRUxfMThfMCwgUkVMXzE4X1NU QUJMRSwgbWFzdGVyCm1hc3Rlci9iaW4vcGdfZHVtcCB0ZXN0IHByb2R1Y2VzOgoKLi4uCkNSRUFU RSBUQUJMRSBwdWJsaWMucCAoCmEgaW50ZWdlcgopOwoKCkFMVEVSIFRBQkxFIHB1YmxpYy5wIE9X TkVSIFRPIGFuZHJldzsKCi0tCi0tIE5hbWU6IGM7IFR5cGU6IFRBQkxFOyBTY2hlbWE6IHB1Ymxp YzsgT3duZXI6IEFuZHJldwotLQoKQ1JFQVRFIFRBQkxFIHB1YmxpYy5jICgKKQpJTkhFUklUUyAo cHVibGljLnApOwoKCkFMVEVSIFRBQkxFIHB1YmxpYy5jIE9XTkVSIFRPIGFuZHJldzsKCi0tCi0t IERhdGEgZm9yIE5hbWU6IGM7IFR5cGU6IFRBQkxFIERBVEE7IFNjaGVtYTogcHVibGljOyBPd25l cjogQW5kcmV3Ci0tCgpDT1BZIHB1YmxpYy5jIChhKSBGUk9NIHN0ZGluOwpcLgouLi4KCmFuZCBs b3NlcyBOT1QgTlVMTCBpbiB0aGUgaW5oZXJpdGVkIHRhYmxlCgpSZWdhcmRzLCBBbmRyZXcKCg== --===============0862882468368737977==--