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 1qZV32-005cgY-V7 for pgsql-committers@arkaria.postgresql.org; Fri, 25 Aug 2023 11:32:17 +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 1qZV31-002ScE-8M for pgsql-committers@arkaria.postgresql.org; Fri, 25 Aug 2023 11:32:15 +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 1qZV30-002Sbt-SR for pgsql-committers@lists.postgresql.org; Fri, 25 Aug 2023 11:32:14 +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 1qZV2x-000soT-60 for pgsql-committers@lists.postgresql.org; Fri, 25 Aug 2023 11:32:13 +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 1qZV2w-0005AD-Iq for pgsql-committers@lists.postgresql.org; Fri, 25 Aug 2023 11:32:10 +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 1qZV2v-000p1M-8n for pgsql-committers@lists.postgresql.org; Fri, 25 Aug 2023 11:32:09 +0000 Content-Type: multipart/mixed; boundary="===============0412005354053301988==" 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, 25 Aug 2023 11:32:09 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0412005354053301988== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q2F0YWxvZyBub3QtbnVsbCBjb25zdHJhaW50cwoKV2Ugbm93IGNyZWF0ZSBjb250eXBlPSduJyBw Z19jb25zdHJhaW50IHJvd3MgZm9yIG5vdC1udWxsIGNvbnN0cmFpbnRzLgoKV2UgcHJvcGFnYXRl IHRoZXNlIGNvbnN0cmFpbnRzIHRvIG90aGVyIHRhYmxlcyBkdXJpbmcgb3BlcmF0aW9ucyBzdWNo IGFzCmFkZGluZyBpbmhlcml0YW5jZSByZWxhdGlvbnNoaXBzLCBjcmVhdGluZyBhbmQgYXR0YWNo aW5nIHBhcnRpdGlvbnMgYW5kCmNyZWF0aW5nIHRhYmxlcyBMSUtFIG90aGVyIHRhYmxlcy4gIFdl IGFsc28gc3Bhd24gbm90LW51bGwgY29uc3RyYWludHMKZm9yIGluaGVyaXRhbmNlIGNoaWxkIHRh YmxlcyB3aGVuIHRoZWlyIHBhcmVudHMgaGF2ZSBwcmltYXJ5IGtleXMuClRoZXNlIHJlbGF0ZWQg Y29uc3RyYWludHMgbW9zdGx5IGZvbGxvdyB0aGUgd2VsbC1rbm93biBydWxlcyBvZgpjb25pc2xv Y2FsIGFuZCBjb25pbmhjb3VudCB0aGF0IHdlIGhhdmUgZm9yIENIRUNLIGNvbnN0cmFpbnRzLCB3 aXRoIHNvbWUKYWRhcHRhdGlvbnM6IGZvciBleGFtcGxlLCBhcyBvcHBvc2VkIHRvIENIRUNLIGNv bnN0cmFpbnRzLCB3ZSBkb24ndAptYXRjaCBub3QtbnVsbCBvbmVzIGJ5IG5hbWUgd2hlbiBkZXNj ZW5kaW5nIGEgaGllcmFyY2h5IHRvIGFsdGVyIGl0LAppbnN0ZWFkIG1hdGNoaW5nIGJ5IGNvbHVt biBuYW1lIHRoYXQgdGhleSBhcHBseSB0by4gIFRoaXMgbWVhbnMgd2UgZG9uJ3QKcmVxdWlyZSB0 aGUgY29uc3RyYWludCBuYW1lcyB0byBiZSBpZGVudGljYWwgYWNyb3NzIGEgaGllcmFyY2h5LgoK Rm9yIG5vdywgd2Ugb21pdCB0aGVtIGZvciBzeXN0ZW0gY2F0YWxvZ3MuICBNYXliZSB0aGlzIGlz IHdvcnRoCnJlY29uc2lkZXJpbmcuICBXZSBkb24ndCBzdXBwb3J0IE5PVCBWQUxJRCBub3IgREVG RVJSQUJMRSBjbGF1c2VzCmVpdGhlcjsgdGhlc2UgY2FuIGJlIGFkZGVkIGFzIHNlcGFyYXRlIGZl YXR1cmVzIGxhdGVyICh0aGlzIHBhdGNoIGlzCmFscmVhZHkgbGFyZ2UgYW5kIGNvbXBsaWNhdGVk IGVub3VnaC4pCgpwc3FsIHNob3dzIHRoZXNlIGNvbnN0cmFpbnRzIGluIFxkKy4KCnBnX2R1bXAg cmVxdWlyZXMgc29tZSBhZC1ob2MgaGFja3MsIHBhcnRpY3VsYXJseSB3aGVuIGR1bXBpbmcgYSBw cmltYXJ5CmtleS4gIFdlIG5vdyBjcmVhdGUgb25lICJ0aHJvd2F3YXkiIG5vdC1udWxsIGNvbnN0 cmFpbnQgZm9yIGVhY2ggY29sdW1uCmluIHRoZSBQSyB0b2dldGhlciB3aXRoIHRoZSBDUkVBVEUg VEFCTEUgY29tbWFuZCwgYW5kIG9uY2UgdGhlIFBLIGlzCmNyZWF0ZWQsIGFsbCB0aG9zZSB0aHJv d2F3YXkgY29uc3RyYWludHMgYXJlIHJlbW92ZWQuICBUaGlzIGF2b2lkcwpoYXZpbmcgdG8gY2hl Y2sgZWFjaCB0dXBsZSBmb3IgbnVsbG5lc3Mgd2hlbiB0aGUgZHVtcCByZXN0b3JlcyB0aGUKcHJp bWFyeSBrZXkgY3JlYXRpb24uCgpwZ191cGdyYWRpbmcgZnJvbSBhbiBvbGRlciByZWxlYXNlIHJl cXVpcmVzIGEgc29tZXdoYXQgYnJpdHRsZSBwcm9jZWR1cmUKdG8gY3JlYXRlIGEgY29uc3RyYWlu dCBzdGF0ZSB0aGF0IG1hdGNoZXMgd2hhdCB3b3VsZCBiZSBjcmVhdGVkIGlmIHRoZQpkYXRhYmFz ZSB3ZXJlIGJlaW5nIGNyZWF0ZWQgZnJlc2ggaW4gUG9zdGdyZXMgMTcuICBJIGhhdmUgdGVzdGVk IGFsbCB0aGUKc2NlbmFyaW9zIEkgY291bGQgdGhpbmsgb2YsIGFuZCBpdCB3b3JrcyBjb3JyZWN0 bHkgYXMgZmFyIGFzIEkgY2FuIHRlbGwsCmJ1dCBJIGNvdWxkIGhhdmUgbmVnbGVjdGVkIHdlaXJk IGNhc2VzLgoKVGhpcyBwYXRjaCBoYXMgYmVlbiB2ZXJ5IGxvbmcgaW4gdGhlIG1ha2luZy4gIFRo ZSBmaXJzdCBwYXRjaCB3YXMKd3JpdHRlbiBieSBCZXJuZCBIZWxtbGUgaW4gMjAxMCB0byBhZGQg YSBuZXcgcGdfY29uc3RyYWludC5jb250eXBlIHZhbHVlCignbicpLCB3aGljaCBJICjDgWx2YXJv KSB0aGVuIGhpamFja2VkIGluIDIwMTEgYW5kIDIwMTIsIHVudGlsIHRoYXQgb25lCndhcyBraWxs ZWQgYnkgdGhlIHJlYWxpemF0aW9uIHRoYXQgd2Ugb3VnaHQgdG8gdXNlIGNvbnR5cGU9J2MnIGlu c3RlYWQ6Cm1hbnVmYWN0dXJlZCBDSEVDSyBjb25zdHJhaW50cy4gIEhvd2V2ZXIsIGxhdGVyIFNR TCBzdGFuZGFyZApkZXZlbG9wbWVudCwgYXMgd2VsbCBhcyBub25vYnZpb3VzIGVtZXJnZW50IHBy b3BlcnRpZXMgb2YgdGhhdCBkZXNpZ24KKG1vc3RseSwgZmFpbHVyZSB0byBkaXN0aW5ndWlzaCB0 aGVtIGZyb20gIm5vcm1hbCIgQ0hFQ0sgY29uc3RyYWludHMgYXMKd2VsbCBhcyB0aGUgcGVyZm9y bWFuY2UgaW1wbGljYXRpb24gb2YgaGF2aW5nIHRvIHRlc3QgdGhlIENIRUNLCmV4cHJlc3Npb24p IGxlZCB1cyB0byByZWNvbnNpZGVyIHRoaXMgY2hvaWNlLCBzbyBub3cgdGhlIGN1cnJlbnQKaW1w bGVtZW50YXRpb24gdXNlcyBjb250eXBlPSduJyBhZ2Fpbi4gIER1cmluZyBQb3N0Z3JlcyAxNiB0 aGlzIGhhZAphbHJlYWR5IGJlZW4gaW50cm9kdWNlZCBieSBjb21taXQgZTA1NmM1NTdhZWY0LCBi dXQgdGhlcmUgd2VyZSBzb21lCnByb2JsZW1zIG1haW5seSB3aXRoIHRoZSBwZ191cGdyYWRlIHBy b2NlZHVyZSB0aGF0IGNvdWxkbid0IGJlIGZpeGVkIGluCnJlYXNvbmFibGUgdGltZSwgc28gaXQg d2FzIHJldmVydGVkLgoKSW4gMjAxNiBWaXRhbHkgQnVyb3ZveSBhbHNvIHdvcmtlZCBvbiB0aGlz IGZlYXR1cmVbMV0gYnV0IGZvdW5kIG5vCmNvbnNlbnN1cyBmb3IgaGlzIHByb3Bvc2VkIGFwcHJv YWNoLCB3aGljaCB3YXMgY2xhaW1lZCB0byBiZSBjbG9zZXIgdG8KdGhlIGxldHRlciBvZiB0aGUg c3RhbmRhcmQsIHJlcXVpcmluZyBhbiBhZGRpdGlvbmFsIHBnX2F0dHJpYnV0ZSBjb2x1bW4KdG8g dHJhY2sgdGhlIE9JRCBvZiB0aGUgbm90LW51bGwgY29uc3RyYWludCBmb3IgdGhhdCBjb2x1bW4u ClsxXSBodHRwczovL3Bvc3Rnci5lcy9tL0NBS09TV05rTjZIU3lhdHV5czh4Wnh6UkNSLUtMMU9r SFM1LWI5cWQ5YmYxUmFkM1BMQUBtYWlsLmdtYWlsLmNvbQoKQXV0aG9yOiDDgWx2YXJvIEhlcnJl cmEgPGFsdmhlcnJlQGFsdmgubm8taXAub3JnPgpBdXRob3I6IEJlcm5kIEhlbG1sZSA8bWFpbGlu Z3NAb29wc3dhcmUuZGU+ClJldmlld2VkLWJ5OiBKdXN0aW4gUHJ5emJ5IDxwcnl6YnlAdGVsc2Fz b2Z0LmNvbT4KUmV2aWV3ZWQtYnk6IFBldGVyIEVpc2VudHJhdXQgPHBldGVyLmVpc2VudHJhdXRA ZW50ZXJwcmlzZWRiLmNvbT4KUmV2aWV3ZWQtYnk6IERlYW4gUmFzaGVlZCA8ZGVhbi5hLnJhc2hl ZWRAZ21haWwuY29tPgoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRw czovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2IwZTk2ZjMxMTk4NWJjZWJhNzk4 MjUyMTRmOGU0M2Y2NWFmYTY1M2EKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmNvbnRy aWIvc2VwZ3NxbC9leHBlY3RlZC9hbHRlci5vdXQgICAgICAgICAgICAgICAgIHwgICAgMyAtCmNv bnRyaWIvc2VwZ3NxbC9leHBlY3RlZC9kZGwub3V0ICAgICAgICAgICAgICAgICAgIHwgICAgMiAr CmNvbnRyaWIvdGVzdF9kZWNvZGluZy9leHBlY3RlZC9kZGwub3V0ICAgICAgICAgICAgIHwgICAx MiArCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgIHwg ICAxMSArLQpkb2Mvc3JjL3NnbWwvZGRsLnNnbWwgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICB8ICAgNTUgKy0KZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl90YWJsZS5zZ21sICAgICAgICAgICAg ICAgICAgfCAgIDExICstCmRvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwgICAgICAg ICAgICAgICAgIHwgICAgOCArLQpzcmMvYmFja2VuZC9jYXRhbG9nL2hlYXAuYyAgICAgICAgICAg ICAgICAgICAgICAgICB8ICA1MjkgKysrKystLQpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX2NvbnN0 cmFpbnQuYyAgICAgICAgICAgICAgICB8ICAyODYgKysrKwpzcmMvYmFja2VuZC9jb21tYW5kcy90 YWJsZWNtZHMuYyAgICAgICAgICAgICAgICAgICB8IDE1OTUgKysrKysrKysrKysrKystLS0tLS0K c3JjL2JhY2tlbmQvbm9kZXMvb3V0ZnVuY3MuYyAgICAgICAgICAgICAgICAgICAgICAgfCAgICA1 ICsKc3JjL2JhY2tlbmQvbm9kZXMvcmVhZGZ1bmNzLmMgICAgICAgICAgICAgICAgICAgICAgfCAg ICA5ICstCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BsYW5jYXQuYyAgICAgICAgICAgICAg IHwgICAgMiArCnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkgICAgICAgICAgICAgICAgICAgICAg ICAgIHwgICAxOSArLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfdXRpbGNtZC5jICAgICAgICAg ICAgICAgICB8ICAyNzcgKysrLQpzcmMvYmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxzLmMgICAg ICAgICAgICAgICAgICB8ICAgMTQgKwpzcmMvYmFja2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5j ICAgICAgICAgICAgICAgICB8ICAgMzQgKy0Kc3JjL2Jpbi9wZ19kdW1wL2NvbW1vbi5jICAgICAg ICAgICAgICAgICAgICAgICAgICAgfCAgIDE4ICstCnNyYy9iaW4vcGdfZHVtcC9wZ19kdW1wLmMg ICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDI5MiArKystCnNyYy9iaW4vcGdfZHVtcC9wZ19k dW1wLmggICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAgOSArLQpzcmMvYmluL3BnX2R1bXAv dC8wMDJfcGdfZHVtcC5wbCAgICAgICAgICAgICAgICAgICB8ICAgMTAgKy0Kc3JjL2Jpbi9wc3Fs L2Rlc2NyaWJlLmMgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDQ0ICsKc3JjL2luY2x1 ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgICAgICAgICAgfCAgICAyICstCnNyYy9p bmNsdWRlL2NhdGFsb2cvaGVhcC5oICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAgOCArLQpz cmMvaW5jbHVkZS9jYXRhbG9nL3BnX2NvbnN0cmFpbnQuaCAgICAgICAgICAgICAgICB8ICAgMTQg Ky0Kc3JjL2luY2x1ZGUvbm9kZXMvcGFyc2Vub2Rlcy5oICAgICAgICAgICAgICAgICAgICAgfCAg IDE2ICstCi4uLi90ZXN0X2RkbF9kZXBhcnNlL2V4cGVjdGVkL2FsdGVyX3RhYmxlLm91dCAgICAg IHwgICAxOCArLQouLi4vdGVzdF9kZGxfZGVwYXJzZS9leHBlY3RlZC9jcmVhdGVfdGFibGUub3V0 ICAgICB8ICAgMjYgKy0KLi4uL21vZHVsZXMvdGVzdF9kZGxfZGVwYXJzZS90ZXN0X2RkbF9kZXBh cnNlLmMgICAgfCAgICA2ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYWx0ZXJfdGFibGUu b3V0ICAgICAgICAgIHwgICA2MiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NsdXN0ZXIu b3V0ICAgICAgICAgICAgICB8ICAgIDcgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jb25z dHJhaW50cy5vdXQgICAgICAgICAgfCAgMjUyICsrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9jcmVhdGVfdGFibGUub3V0ICAgICAgICAgfCAgIDQxICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvY3JlYXRlX3RhYmxlX2xpa2Uub3V0ICAgIHwgICAxMCArCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvZXZlbnRfdHJpZ2dlci5vdXQgICAgICAgIHwgICAgMiArCnNyYy90ZXN0L3JlZ3Jl c3MvZXhwZWN0ZWQvZm9yZWlnbl9kYXRhLm91dCAgICAgICAgIHwgIDEwOCArLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL2ZvcmVpZ25fa2V5Lm91dCAgICAgICAgICB8ICAgMTYgKy0Kc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC9nZW5lcmF0ZWQub3V0ICAgICAgICAgICAgfCAgICAyICsKc3Jj L3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pZGVudGl0eS5vdXQgICAgICAgICAgICAgfCAgICA0ICsK c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pbmRleGluZy5vdXQgICAgICAgICAgICAgfCAgIDQx ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaW5oZXJpdC5vdXQgICAgICAgICAgICAgIHwg IDQ0MiArKysrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wdWJsaWNhdGlvbi5vdXQgICAg ICAgICAgfCAgICA2ICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9yZXBsaWNhX2lkZW50aXR5 Lm91dCAgICAgfCAgIDI0ICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9yb3dzZWN1cml0eS5v dXQgICAgICAgICAgfCAgICAyICsKc3JjL3Rlc3QvcmVncmVzcy9zcWwvYWx0ZXJfdGFibGUuc3Fs ICAgICAgICAgICAgICAgfCAgIDI0ICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NvbnN0cmFpbnRz LnNxbCAgICAgICAgICAgICAgIHwgIDEwMiArKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVf dGFibGUuc3FsICAgICAgICAgICAgICB8ICAgIDYgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvaW5k ZXhpbmcuc3FsICAgICAgICAgICAgICAgICAgfCAgICA4ICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L2luaGVyaXQuc3FsICAgICAgICAgICAgICAgICAgIHwgIDE4MyArKysKc3JjL3Rlc3QvcmVncmVz cy9zcWwvcmVwbGljYV9pZGVudGl0eS5zcWwgICAgICAgICAgfCAgIDE1ICsKNTAgZmlsZXMgY2hh bmdlZCwgMzkyOCBpbnNlcnRpb25zKCspLCA3NjQgZGVsZXRpb25zKC0pCgo= --===============0412005354053301988==--