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 1pkqWi-0000Lw-Lb for pgsql-committers@arkaria.postgresql.org; Fri, 07 Apr 2023 18:09:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkqWg-0004Ne-BR for pgsql-committers@arkaria.postgresql.org; Fri, 07 Apr 2023 18:09:30 +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 1pkqWg-0004NV-32 for pgsql-committers@lists.postgresql.org; Fri, 07 Apr 2023 18:09:30 +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.94.2) (envelope-from ) id 1pkqWc-001UKk-MV for pgsql-committers@lists.postgresql.org; Fri, 07 Apr 2023 18:09:29 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkqWa-0002fs-JT for pgsql-committers@lists.postgresql.org; Fri, 07 Apr 2023 18:09:24 +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 1pkqWY-001tjI-JC for pgsql-committers@lists.postgresql.org; Fri, 07 Apr 2023 18:09:23 +0000 Content-Type: multipart/mixed; boundary="===============5026219553622555593==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Catalog NOT NULL constraints X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 07 Apr 2023 18:09:23 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5026219553622555593== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q2F0YWxvZyBOT1QgTlVMTCBjb25zdHJhaW50cwoKV2Ugbm93IGNyZWF0ZSBwZ19jb25zdGFpbnQg cm93cyBmb3IgTk9UIE5VTEwgY29uc3RyYWludHMgd2l0aApjb250eXBlPSduJy4KCldlIHByb3Bh Z2F0ZSB0aGVzZSBjb25zdHJhaW50cyBkdXJpbmcgb3BlcmF0aW9ucyBzdWNoIGFzIGFkZGluZwpp bmhlcml0YW5jZSByZWxhdGlvbnNoaXBzLCBjcmVhdGluZyBhbmQgYXR0YWNoaW5nIHBhcnRpdGlv bnMsIGNyZWF0aW5nCnRhYmxlcyBMSUtFIG90aGVyIHRhYmxlcy4gIFdlIG1vc3RseSBmb2xsb3cg dGhlIHdlbGwta25vd24gcnVsZXMgb2YKY29uaXNsb2NhbCBhbmQgY29uaW5oY291bnQgdGhhdCB3 ZSBoYXZlIGZvciBDSEVDSyBjb25zdHJhaW50cywgd2l0aCBzb21lCmFkYXB0YXRpb25zOyBmb3Ig ZXhhbXBsZSwgYXMgb3Bwb3NlZCB0byBDSEVDSyBjb25zdHJhaW50cywgd2UgZG9uJ3QKbWF0Y2gg Tk9UIE5VTEwgb25lcyBieSBuYW1lIHdoZW4gZGVzY2VuZGluZyBhIGhpZXJhcmNoeSB0byBhbHRl ciBpdDsKaW5zdGVhZCB3ZSBtYXRjaCBieSBjb2x1bW4gbnVtYmVyLiAgVGhpcyBtZWFucyB3ZSBk b24ndCByZXF1aXJlIHRoZQpjb25zdHJhaW50IG5hbWVzIHRvIGJlIGlkZW50aWNhbCBhY3Jvc3Mg YSBoaWVyYXJjaHkuCgpGb3Igbm93LCB3ZSBvbWl0IHRoZW0gZnJvbSBzeXN0ZW0gY2F0YWxvZ3Mu ICBNYXliZSB0aGlzIGlzIHdvcnRoCnJlY29uc2lkZXJpbmcuICBXZSBkb24ndCBzdXBwb3J0IE5P VCBWQUxJRCBub3IgREVGRVJSQUJMRSBjbGF1c2VzCmVpdGhlcjsgdGhlc2UgY2FuIGJlIGFkZGVk IGFzIHNlcGFyYXRlIGZlYXR1cmVzIGxhdGVyICh0aGlzIHBhdGNoIGlzCmFscmVhZHkgbGFyZ2Ug YW5kIGNvbXBsaWNhdGVkIGVub3VnaC4pCgpUaGlzIGhhcyBiZWVuIHZlcnkgbG9uZyBpbiB0aGUg bWFraW5nLiAgVGhlIGZpcnN0IHBhdGNoIHdhcyB3cml0dGVuIGJ5CkJlcm5kIEhlbG1sZSBpbiAy MDEwIHRvIGFkZCBhIG5ldyBwZ19jb25zdHJhaW50LmNvbnR5cGUgdmFsdWUgKCduJyksCndoaWNo IEkgKMOBbHZhcm8pIHRoZW4gaGlqYWNrZWQgaW4gMjAxMSBhbmQgMjAxMiwgdW50aWwgdGhhdCBv bmUgd2FzCmtpbGxlZCBieSB0aGUgcmVhbGl6YXRpb24gdGhhdCB3ZSBvdWdodCB0byB1c2UgY29u dHlwZT0nYycgaW5zdGVhZDoKbWFudWZhY3R1cmVkIENIRUNLIGNvbnN0cmFpbnRzLiAgSG93ZXZl ciwgbGF0ZXIgU1FMIHN0YW5kYXJkCmRldmVsb3BtZW50LCBhcyB3ZWxsIGFzIG5vbm9idmlvdXMg ZW1lcmdlbnQgcHJvcGVydGllcyBvZiB0aGF0IGRlc2lnbgoobW9zdGx5LCBmYWlsdXJlIHRvIGRp c3Rpbmd1aXNoIHRoZW0gZnJvbSAibm9ybWFsIiBDSEVDSyBjb25zdHJhaW50cyBhcwp3ZWxsIGFz IHRoZSBwZXJmb3JtYW5jZSBpbXBsaWNhdGlvbiBvZiBoYXZpbmcgdG8gdGVzdCB0aGUgQ0hFQ0sK ZXhwcmVzc2lvbikgbGVkIHVzIHRvIHJlY29uc2lkZXIgdGhpcyBjaG9pY2UsIHNvIG5vdyB0aGUg Y3VycmVudAppbXBsZW1lbnRhdGlvbiB1c2VzIGNvbnR5cGU9J24nIGFnYWluLgoKSW4gMjAxNiBW aXRhbHkgQnVyb3ZveSBhbHNvIHdvcmtlZCBvbiB0aGlzIGZlYXR1cmVbMV0gYnV0IGZvdW5kIG5v CmNvbnNlbnN1cyBmb3IgaGlzIHByb3Bvc2VkIGFwcHJvYWNoLCB3aGljaCB3YXMgY2xhaW1lZCB0 byBiZSBjbG9zZXIgdG8KdGhlIGxldHRlciBvZiB0aGUgc3RhbmRhcmQsIHJlcXVpcmluZyBhZGRp dGlvbmFsIHBnX2F0dHJpYnV0ZSBjb2x1bW5zIHRvCnRyYWNrIHRoZSBPSUQgb2YgdGhlIE5PVCBO VUxMIGNvbnN0cmFpbnQgZm9yIHRoYXQgY29sdW1uLgpbMV0gaHR0cHM6Ly9wb3N0Z3IuZXMvbS9D QUtPU1dOa042SFN5YXR1eXM4eFp4elJDUi1LTDFPa0hTNS1iOXFkOWJmMVJhZDNQTEFAbWFpbC5n bWFpbC5jb20KCkF1dGhvcjogw4FsdmFybyBIZXJyZXJhIDxhbHZoZXJyZUBhbHZoLm5vLWlwLm9y Zz4KQXV0aG9yOiBCZXJuZCBIZWxtbGUgPG1haWxpbmdzQG9vcHN3YXJlLmRlPgpSZXZpZXdlZC1i eTogSnVzdGluIFByeXpieSA8cHJ5emJ5QHRlbHNhc29mdC5jb20+ClJldmlld2VkLWJ5OiBQZXRl ciBFaXNlbnRyYXV0IDxwZXRlci5laXNlbnRyYXV0QGVudGVycHJpc2VkYi5jb20+CgpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQ0EwRTY0MkEwMjY3RURBMzg3QUYyQiU0MCU1QjE3 Mi4yNi4xNC42MiU1RApEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0FBTkxrVGluTFhN T0VNeiswSjI5dGYxUE9va0tpNFhEa1dKNi1ERFI5QktnVUBtYWlsLmdtYWlsLmNvbQpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzIwMTEwNzA3MjEzNDAxLkdBMjcwOThAYWx2aC5uby1p cC5vcmcKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xMzQzNjgyNjY5LXN1cC0yNTMy QGFsdmgubm8taXAub3JnCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FLT1NXTmtO NkhTeWF0dXlzOHhaeHpSQ1ItS0wxT2tIUzUtYjlxZDliZjFSYWQzUExBQG1haWwuZ21haWwuY29t CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMjAyMjA4MTcxODEyNDkucTdxdmozb2t5 d2N0cmEzY0BhbHZoZXJyZS5wZ3NxbAoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0t LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2UwNTZjNTU3YWVm NDAwNmMzZGZiZjhhNGI5NGI3YWU4OGViOWZkNjcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0t LS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgIHwg ICAgMSArCmRvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbCAgICAgICAgICAgICAgICAg IHwgICAxNCArLQpkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICAgICAgICAg ICAgICB8ICAgIDggKy0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9oZWFwLmMgICAgICAgICAgICAgICAg ICAgICAgICAgfCAgNDkxICsrKysrKy0tCnNyYy9iYWNrZW5kL2NhdGFsb2cvcGdfY29uc3RyYWlu dC5jICAgICAgICAgICAgICAgIHwgICA5NyArKwpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNt ZHMuYyAgICAgICAgICAgICAgICAgICB8IDEzMjYgKysrKysrKysrKysrKysrLS0tLS0Kc3JjL2Jh Y2tlbmQvbm9kZXMvb3V0ZnVuY3MuYyAgICAgICAgICAgICAgICAgICAgICAgfCAgICA0ICsKc3Jj L2JhY2tlbmQvbm9kZXMvcmVhZGZ1bmNzLmMgICAgICAgICAgICAgICAgICAgICAgfCAgICA4ICst CnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BsYW5jYXQuYyAgICAgICAgICAgICAgIHwgICAg MiArCnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkgICAgICAgICAgICAgICAgICAgICAgICAgIHwg ICAxMyArCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV91dGlsY21kLmMgICAgICAgICAgICAgICAg IHwgIDIwNiArKy0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3J1bGV1dGlscy5jICAgICAgICAgICAg ICAgICAgfCAgIDE0ICsKc3JjL2Jpbi9wZ19kdW1wL2NvbW1vbi5jICAgICAgICAgICAgICAgICAg ICAgICAgICAgfCAgIDE1ICstCnNyYy9iaW4vcGdfZHVtcC9wZ19iYWNrdXBfYXJjaGl2ZXIuYyAg ICAgICAgICAgICAgIHwgICAgMiArCnNyYy9iaW4vcGdfZHVtcC9wZ19kdW1wLmMgICAgICAgICAg ICAgICAgICAgICAgICAgIHwgIDIwOSArKy0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuaCAgICAg ICAgICAgICAgICAgICAgICAgICAgfCAgICAyICstCnNyYy9iaW4vcGdfZHVtcC90LzAwMl9wZ19k dW1wLnBsICAgICAgICAgICAgICAgICAgIHwgICAgNiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2Nh dHZlcnNpb24uaCAgICAgICAgICAgICAgICAgICB8ICAgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxv Zy9oZWFwLmggICAgICAgICAgICAgICAgICAgICAgICAgfCAgICA3ICstCnNyYy9pbmNsdWRlL2Nh dGFsb2cvcGdfY29uc3RyYWludC5oICAgICAgICAgICAgICAgIHwgICAxMSArLQpzcmMvaW5jbHVk ZS9jb21tYW5kcy90YWJsZWNtZHMuaCAgICAgICAgICAgICAgICAgICB8ICAgIDIgKwpzcmMvaW5j bHVkZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAgICAgICAgICAgICAgICB8ICAgMTQgKy0KLi4u L3Rlc3RfZGRsX2RlcGFyc2UvZXhwZWN0ZWQvYWx0ZXJfdGFibGUub3V0ICAgICAgfCAgIDE4ICst Ci4uLi90ZXN0X2RkbF9kZXBhcnNlL2V4cGVjdGVkL2NyZWF0ZV90YWJsZS5vdXQgICAgIHwgICAy NSArLQouLi4vbW9kdWxlcy90ZXN0X2RkbF9kZXBhcnNlL3Rlc3RfZGRsX2RlcGFyc2UuYyAgICB8 ICAgIDQgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2FsdGVyX3RhYmxlLm91dCAgICAgICAg ICB8ICAgNTAgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jbHVzdGVyLm91dCAgICAgICAg ICAgICAgfCAgICA3ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY29uc3RyYWludHMub3V0 ICAgICAgICAgIHwgIDExNCArKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NyZWF0ZV90YWJs ZS5vdXQgICAgICAgICB8ICAgMjcgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ldmVudF90 cmlnZ2VyLm91dCAgICAgICAgfCAgICAyICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9mb3Jl aWduX2RhdGEub3V0ICAgICAgICAgfCAgIDExICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv Zm9yZWlnbl9rZXkub3V0ICAgICAgICAgIHwgICAxNiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL2luZGV4aW5nLm91dCAgICAgICAgICAgICB8ICAgNDEgKy0Kc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9pbmhlcml0Lm91dCAgICAgICAgICAgICAgfCAgNDA1ICsrKysrKwpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL3JlcGxpY2FfaWRlbnRpdHkub3V0ICAgICB8ICAgMTMgKwpzcmMvdGVz dC9yZWdyZXNzL3BhcmFsbGVsX3NjaGVkdWxlICAgICAgICAgICAgICAgICB8ICAgIDMgKy0Kc3Jj L3Rlc3QvcmVncmVzcy9zcWwvYWx0ZXJfdGFibGUuc3FsICAgICAgICAgICAgICAgfCAgIDI2ICst CnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NvbnN0cmFpbnRzLnNxbCAgICAgICAgICAgICAgIHwgICA0 MyArCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NyZWF0ZV90YWJsZS5zcWwgICAgICAgICAgICAgIHwg ICAgNiArLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9pbmRleGluZy5zcWwgICAgICAgICAgICAgICAg ICB8ICAgIDggKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvaW5oZXJpdC5zcWwgICAgICAgICAgICAg ICAgICAgfCAgMjA4ICsrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9yZXBsaWNhX2lkZW50aXR5LnNx bCAgICAgICAgICB8ICAgMTIgKwo0MiBmaWxlcyBjaGFuZ2VkLCAyODY4IGluc2VydGlvbnMoKyks IDYyNSBkZWxldGlvbnMoLSkKCg== --===============5026219553622555593==--