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 1rxRxZ-008lqg-0S for pgsql-committers@arkaria.postgresql.org; Thu, 18 Apr 2024 13:37:53 +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 1rxRxX-0053Ai-Ah for pgsql-committers@arkaria.postgresql.org; Thu, 18 Apr 2024 13:37:51 +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 1rxRxX-0053AU-3P for pgsql-committers@lists.postgresql.org; Thu, 18 Apr 2024 13:37:51 +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 1rxRxR-003SbE-3r for pgsql-committers@lists.postgresql.org; Thu, 18 Apr 2024 13:37:49 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rxRxP-008emh-R5 for pgsql-committers@lists.postgresql.org; Thu, 18 Apr 2024 13:37:44 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rxRxO-002hM4-Lk for pgsql-committers@lists.postgresql.org; Thu, 18 Apr 2024 13:37:43 +0000 Content-Type: multipart/mixed; boundary="===============7688868761033952807==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix restore of not-null constraints with inheritance X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 18 Apr 2024 13:37:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7688868761033952807== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJlc3RvcmUgb2Ygbm90LW51bGwgY29uc3RyYWludHMgd2l0aCBpbmhlcml0YW5jZQoKSW4g dGFibGVzIHdpdGggcHJpbWFyeSBrZXlzLCBwZ19kdW1wIGNyZWF0ZXMgdGFibGVzIHdpdGggcHJp bWFyeSBrZXlzIGJ5CmluaXRpYWxseSBkdW1waW5nIHRoZW0gd2l0aCB0aHJvdy1hd2F5IG5vdC1u dWxsIGNvbnN0cmFpbnRzIChtYXJrZWQgIm5vCmluaGVyaXQiIHNvIHRoYXQgdGhleSBkb24ndCBj cmVhdGUgcHJvYmxlbXMgZWxzZXdoZXJlKSwgdG8gbGF0ZXIgZHJvcAp0aGVtIG9uY2UgdGhlIHBy aW1hcnkga2V5IGlzIHJlc3RvcmVkLiAgQmVjYXVzZSBvZiBhIHVucmVsYXRlZApjb25zaWRlcmF0 aW9uLCBvbiB0YWJsZXMgd2l0aCBjaGlsZHJlbiB3ZSBhZGQgbm90LW51bGwgY29uc3RyYWludHMg dG8KYWxsIGNvbHVtbnMgb2YgdGhlIHByaW1hcnkga2V5IHdoZW4gaXQgaXMgY3JlYXRlZC4KCklm IGJvdGggYSB0YWJsZSBhbmQgaXRzIGNoaWxkIGhhdmUgcHJpbWFyeSBrZXlzLCBhbmQgcGdfZHVt cCBoYXBwZW5zIHRvCmVtaXQgdGhlIGNoaWxkIHRhYmxlIGZpcnN0IChhbmQgaXRzIHRocm93LWF3 YXkgbm90LW51bGwpIGFuZCBsYXRlciBpdHMKcGFyZW50IHRhYmxlLCB0aGUgY3JlYXRpb24gb2Yg dGhlIHBhcmVudCdzIFBLIHdpbGwgZmFpbCBiZWNhdXNlIHRoZQp0aHJvdy1hd2F5IG5vdC1udWxs IGNvbnN0cmFpbnQgY29sbGlkZXMgd2l0aCB0aGUgcGVybWFuZW50IG5vdC1udWxsCmNvbnN0cmFp bnQgdGhhdCB0aGUgUEsgd2FudHMgdG8gYWRkLCBzbyB0aGUgZHVtcCBmYWlscyB0byByZXN0b3Jl LgoKV2UgY2FuIHdvcmsgYXJvdW5kIHRoaXMgcHJvYmxlbSBieSBsZXR0aW5nIHRoZSBwcmltYXJ5 IGtleSAidGFrZSBvdmVyIgp0aGUgY2hpbGQncyBub3QtbnVsbC4gIFRoaXMgcmVxdWlyZXMgbm8g Y2hhbmdlcyB0byBwZ19kdW1wLCBqdXN0IHR3bwpjaGFuZ2VzIHRvIEFMVEVSIFRBQkxFOiBmaXJz dCwgdGhlIGFiaWxpdHkgdG8gY29udmVydCBhIG5vLWluaGVyaXQKbm90LW51bGwgY29uc3RyYWlu dCBpbnRvIGEgcmVndWxhciBpbmhlcml0YWJsZSBvbmUgKGluY2x1ZGluZyByZWN1cnNpbmcKZG93 biB0byBjaGlsZHJlbiwgaWYgdGhlcmUgYXJlIGFueSk7IHNlY29uZCwgdGhlIGFiaWxpdHkgdG8g ImRyb3AiIGEKY29uc3RyYWludCB0aGF0IGlzIGRlZmluZWQgYm90aCBkaXJlY3RseSBpbiB0aGUg dGFibGUgYW5kIGluaGVyaXRlZCBmcm9tCmEgcGFyZW50ICh3aGljaCBzaW1wbHkgbWVhbnMgdG8g bWFyayBpdCBhcyBubyBsb25nZXIgaGF2aW5nIGEgbG9jYWwKZGVmaW5pdGlvbikuCgpTZWNvbmRh cmlseSwgY2hhbmdlIEFUUHJlcEFkZFByaW1hcnlLZXkoKSB0byBhY3F1aXJlIGxvY2tzIGFsbCB0 aGUgd2F5CmRvd24gdGhlIGluaGVyaXRhbmNlIGhpZXJhcmNoeSwgaW4gY2FzZSB3ZSBuZWVkIHRv IHJlY3Vyc2Ugd2hlbgpwcm9wYWdhdGluZyBjb25zdHJhaW50cy4KClRoZXNlIHR3byBjaGFuZ2Vz IGFsbG93IHBnX2R1bXAgdG8gcmVwcm9kdWNlIG1vcmUgY2FzZXMgaW52b2x2aW5nCmluaGVyaXRh bmNlIGZyb20gdmVyc2lvbnMgMTYgYW5kIG9sZGVyLgoKTGFzdGx5LCBtYWtlIHR3byBjaGFuZ2Vz IHRvIHBnX2R1bXA6IDEpIGRvIG5vdCB0cnkgdG8gZHJvcCBhIG5vdC1udWxsCmNvbnN0cmFpbnQg dGhhdCdzIG1hcmtlZCBhcyBpbmhlcml0ZWQ7IHRoaXMgYWxsb3dzIGEgZHVtcCB0byByZXN0b3Jl CndpdGggbm8gZXJyb3JzIGlmIGEgdGFibGUgd2l0aCBhIFBLIGluaGVyaXRzIGZyb20gYW5vdGhl ciB3aGljaCBhbHNvIGhhcwphIFBLOyAyKSBhdm9pZCBnaXZpbmcgaW5oZXJpdGVkIGNvbnN0cmFp bnRzIHRocm93YXdheSBuYW1lcywgZm9yIHRoZQpyYXJlIGNhc2VzIHdoZXJlIHN1Y2ggYSBjb25z dHJhaW50IHN1cnZpdmVzIGFmdGVyIHRoZSByZXN0b3JlLgoKUmVwb3J0ZWQtYnk6IEFuZHJldyBC aWxsZSA8YW5kcmV3YmlsbGVAZ21haWwuY29tPgpSZXBvcnRlZC1ieTogSnVzdGluIFByeXpieSA8 cHJ5emJ5QHRlbHNhc29mdC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FK bnphcndrZlJ1NzZfeWkzZHFWRl9XTC1NcHZUNTR6TXdBeEZ3SmNlWGRIQjc2Yk9BQG1haWwuZ21h aWwuY29tCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vWmgwYUFIN3RiWmItOUhiQ0Bw cnl6YnlqMjAyMwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2Q5ZjY4NmE3MmVlOTFmNjc3M2U1ZDJi YzUyOTk0ZGI4ZDcxNTdhOGUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNr ZW5kL2NhdGFsb2cvaGVhcC5jICAgICAgICAgICAgICAgIHwgMzYgKysrKysrKysrKysrKysrLS0K c3JjL2JhY2tlbmQvY2F0YWxvZy9wZ19jb25zdHJhaW50LmMgICAgICAgfCA0MyArKysrKysrKysr KysrLS0tLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgICB8IDY1 ICsrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAu YyAgICAgICAgICAgICAgICAgfCAyNiArKysrKysrKysrKy0tCnNyYy9pbmNsdWRlL2NhdGFsb2cv cGdfY29uc3RyYWludC5oICAgICAgIHwgIDIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9j b25zdHJhaW50cy5vdXQgfCA1NiArKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9y ZWdyZXNzL3NxbC9jb25zdHJhaW50cy5zcWwgICAgICB8IDIyICsrKysrKysrKysrCjcgZmlsZXMg Y2hhbmdlZCwgMjIxIGluc2VydGlvbnMoKyksIDI5IGRlbGV0aW9ucygtKQoK --===============7688868761033952807==--