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 1s6SqG-00C6f0-9Z for pgsql-committers@arkaria.postgresql.org; Mon, 13 May 2024 10:23:36 +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 1s6SqE-00HMUO-Hx for pgsql-committers@arkaria.postgresql.org; Mon, 13 May 2024 10:23:34 +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 1s6SqE-00HMUG-Ar for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 10:23:34 +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 1s6SqB-000n22-PI for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 10:23:33 +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 1s6SqA-002YEr-MJ for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 10:23:31 +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 1s6Sq9-000kcQ-Ip for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 10:23:30 +0000 Content-Type: multipart/mixed; boundary="===============2654689000911749461==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Revert structural changes to not-null constraints X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 13 May 2024 10:23:30 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2654689000911749461== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmV2ZXJ0IHN0cnVjdHVyYWwgY2hhbmdlcyB0byBub3QtbnVsbCBjb25zdHJhaW50cwoKVGhlcmUg YXJlIHNvbWUgcHJvYmxlbXMgd2l0aCB0aGUgbmV3IHdheSB0byBoYW5kbGUgdGhlc2UgY29uc3Ry YWludHMKdGhhdCB3ZXJlIGRldGVjdGVkIGF0IHRoZSBsYXN0IG1pbnV0ZSwgYW5kIHJlcXVpcmUg Zml4ZXMgdGhhdCBhcHBlYXIgdG9vCmludmFzaXZlIHRvIGJlIGRvaW5nIHRoaXMgbGF0ZSBpbiB0 aGUgY3ljbGUuICBSZXZlcnQgdGhpcyAoYWdhaW4pIGZvcgpub3csIHdlJ2xsIHRyeSBhZ2FpbiB3 aXRoIHRoZXNlIHByb2JsZW1zIGZpeGVkLgoKVGhlIGZvbGxvd2luZyBjb21taXRzIGFyZSByZXZl cnRlZDoKCiAgICBiMGU5NmYzMTE5ODUgIENhdGFsb2cgbm90LW51bGwgY29uc3RyYWludHMKICAg IDliNTgxYzUzNDE4NiAgRGlzYWxsb3cgY2hhbmdpbmcgTk8gSU5IRVJJVCBzdGF0dXMgb2YgYSBu b3QtbnVsbCBjb25zdHJhaW50CiAgICBkMGVjMmRkYmUwODggIEZpeCBub3QtbnVsbCBjb25zdHJh aW50IHRlc3QKICAgIGFjMjJhOTU0NWNhOSAgTW92ZSBwcml2aWxlZ2UgY2hlY2sgdG8gdGhlIHJp Z2h0IHBsYWNlCiAgICBiMGY3ZGQ5MTViY2EgIENoZWNrIHN0YWNrIGRlcHRoIGluIG5ldyByZWN1 cnNpdmUgZnVuY3Rpb25zCiAgICAzYWY3MjE3OTQyNzIgIFVwZGF0ZSBpbmZvcm1hdGlvbl9zY2hl bWEgZGVmaW5pdGlvbiBmb3Igbm90LW51bGwgY29uc3RyYWludHMKICAgIGMzNzA5MTAwYmU3MyAg Rml4IHByb3BhZ2F0aW5nIGF0dG5vdG51bGwgaW4gbXVsdGlwbGUgaW5oZXJpdGFuY2UKICAgIGQ5 ZjY4NmE3MmVlOSAgRml4IHJlc3RvcmUgb2Ygbm90LW51bGwgY29uc3RyYWludHMgd2l0aCBpbmhl cml0YW5jZQogICAgZDcyZDMyZjUyZDI2ICBEb24ndCB0cnkgdG8gYXNzaWduIHNtYXJ0IG5hbWVz IHRvIGNvbnN0cmFpbnRzCiAgICAwY2Q3MTEyNzFkNDIgIEJldHRlciBoYW5kbGUgaW5kaXJlY3Qg Y29uc3RyYWludCBkcm9wcwogICAgMTNkYWEzM2ZhNWE2ICBEaXNhbGxvdyBOTyBJTkhFUklUIG5v dC1udWxsIGNvbnN0cmFpbnRzIG9uIHBhcnRpdGlvbmVkIHRhYmxlcwogICAgZDQ1NTk3ZjcyZmU1 ICBEaXNhbGxvdyBkaXJlY3QgY2hhbmdlIG9mIE5PIElOSEVSSVQgb2Ygbm90LW51bGwgY29uc3Ry YWludHMKICAgIDIxYWMzOGY0OThiMyAgRml4IGluY29uc2lzdGVuY2llcyBpbiBlcnJvciBtZXNz YWdlcwoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMDI0MDUxMTA5NDAuam94bHFj eDRkb2dkQGFsdmhlcnJlLnBnc3FsCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0t LS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNmY4YmI3YzFlOTYx MGRkN2FmMjBjZGFmNzRjNGZmNmU2ZDY3OGQ0NAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0t LS0KY29udHJpYi9zZXBnc3FsL2V4cGVjdGVkL2FsdGVyLm91dCAgICAgICAgICAgICAgICAgfCAg ICAzICsKY29udHJpYi9zZXBnc3FsL2V4cGVjdGVkL2RkbC5vdXQgICAgICAgICAgICAgICAgICAg fCAgICAyIC0KY29udHJpYi90ZXN0X2RlY29kaW5nL2V4cGVjdGVkL2RkbC5vdXQgICAgICAgICAg ICAgfCAgIDEyIC0KZG9jL3NyYy9zZ21sL2NhdGFsb2dzLnNnbWwgICAgICAgICAgICAgICAgICAg ICAgICAgfCAgIDEzICstCmRvYy9zcmMvc2dtbC9kZGwuc2dtbCAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIHwgICA1NSArLQpkb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3RhYmxlLnNnbWwgICAg ICAgICAgICAgICAgICB8ICAgMTMgKy0KZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dt bCAgICAgICAgICAgICAgICAgfCAgICA4ICstCnNyYy9iYWNrZW5kL2NhdGFsb2cvaGVhcC5jICAg ICAgICAgICAgICAgICAgICAgICAgIHwgIDM4NiArLS0tLQpzcmMvYmFja2VuZC9jYXRhbG9nL2lu Zm9ybWF0aW9uX3NjaGVtYS5zcWwgICAgICAgICB8ICAgNzEgKy0Kc3JjL2JhY2tlbmQvY2F0YWxv Zy9wZ19jb25zdHJhaW50LmMgICAgICAgICAgICAgICAgfCAgNDQxICstLS0tLQpzcmMvYmFja2Vu ZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgICAgICAgICAgICB8IDE2NjQgKysrKystLS0t LS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcGxhbmNhdC5jICAgICAgICAg ICAgICAgfCAgICAyIC0Kc3JjL2JhY2tlbmQvcGFyc2VyL2dyYW0ueSAgICAgICAgICAgICAgICAg ICAgICAgICAgfCAgIDE5ICstCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV91dGlsY21kLmMgICAg ICAgICAgICAgICAgIHwgIDI4OCArLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9ydWxldXRpbHMu YyAgICAgICAgICAgICAgICAgIHwgICAyMiAtCnNyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL3JlbGNh Y2hlLmMgICAgICAgICAgICAgICAgIHwgICA0MiArLQpzcmMvYmluL3BnX2R1bXAvY29tbW9uLmMg ICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgMTkgKy0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1 bXAuYyAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgMzIyICstLS0Kc3JjL2Jpbi9wZ19kdW1w L3BnX2R1bXAuaCAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgICA5ICstCnNyYy9iaW4vcGdf ZHVtcC90LzAwMl9wZ19kdW1wLnBsICAgICAgICAgICAgICAgICAgIHwgICAxMCArLQpzcmMvYmlu L3BzcWwvZGVzY3JpYmUuYyAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgNDQgLQpzcmMv aW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAgICAgICAgICAgICB8ICAgIDIgKy0K c3JjL2luY2x1ZGUvY2F0YWxvZy9oZWFwLmggICAgICAgICAgICAgICAgICAgICAgICAgfCAgICA4 ICstCnNyYy9pbmNsdWRlL2NhdGFsb2cvcGdfY29uc3RyYWludC5oICAgICAgICAgICAgICAgIHwg ICAgNyAtCnNyYy9pbmNsdWRlL25vZGVzL3BhcnNlbm9kZXMuaCAgICAgICAgICAgICAgICAgICAg IHwgICAxMSArLQouLi4vdGVzdF9kZGxfZGVwYXJzZS9leHBlY3RlZC9hbHRlcl90YWJsZS5vdXQg ICAgICB8ICAgMTggKy0KLi4uL3Rlc3RfZGRsX2RlcGFyc2UvZXhwZWN0ZWQvY3JlYXRlX3RhYmxl Lm91dCAgICAgfCAgIDI2ICstCi4uLi9tb2R1bGVzL3Rlc3RfZGRsX2RlcGFyc2UvdGVzdF9kZGxf ZGVwYXJzZS5jICAgIHwgICAgNiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2FsdGVyX3Rh YmxlLm91dCAgICAgICAgICB8ICAgMjQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jbHVz dGVyLm91dCAgICAgICAgICAgICAgfCAgICA3ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv Y29uc3RyYWludHMub3V0ICAgICAgICAgIHwgIDUxOCAtLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9jcmVhdGVfdGFibGUub3V0ICAgICAgICAgfCAgIDM1ICstCnNyYy90ZXN0L3JlZ3Jl c3MvZXhwZWN0ZWQvY3JlYXRlX3RhYmxlX2xpa2Uub3V0ICAgIHwgICAxMCAtCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvZXZlbnRfdHJpZ2dlci5vdXQgICAgICAgIHwgICAgMiAtCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvZm9yZWlnbl9kYXRhLm91dCAgICAgICAgIHwgIDEwOCArLQpzcmMv dGVzdC9yZWdyZXNzL2V4cGVjdGVkL2ZvcmVpZ25fa2V5Lm91dCAgICAgICAgICB8ICAgMTYgKy0K c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9nZW5lcmF0ZWQub3V0ICAgICAgICAgICAgfCAgICAy IC0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pZGVudGl0eS5vdXQgICAgICAgICAgICAgfCAg ICA0IC0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pbmRleGluZy5vdXQgICAgICAgICAgICAg fCAgIDM4ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaW5oZXJpdC5vdXQgICAgICAgICAg ICAgIHwgIDUxMCAtLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wYXJ0aXRpb25fbWVy Z2Uub3V0ICAgICAgfCAgICAyIC0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wdWJsaWNhdGlv bi5vdXQgICAgICAgICAgfCAgICA2IC0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9yZXBsaWNh X2lkZW50aXR5Lm91dCAgICAgfCAgIDI0IC0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9yb3dz ZWN1cml0eS5vdXQgICAgICAgICAgfCAgICAyIC0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvYWx0ZXJf dGFibGUuc3FsICAgICAgICAgICAgICAgfCAgIDEyICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2Nv bnN0cmFpbnRzLnNxbCAgICAgICAgICAgICAgIHwgIDIxNyAtLS0Kc3JjL3Rlc3QvcmVncmVzcy9z cWwvaW5kZXhpbmcuc3FsICAgICAgICAgICAgICAgICAgfCAgICA1ICstCnNyYy90ZXN0L3JlZ3Jl c3Mvc3FsL2luaGVyaXQuc3FsICAgICAgICAgICAgICAgICAgIHwgIDIyOSAtLS0Kc3JjL3Rlc3Qv cmVncmVzcy9zcWwvcmVwbGljYV9pZGVudGl0eS5zcWwgICAgICAgICAgfCAgIDE1IC0KNDkgZmls ZXMgY2hhbmdlZCwgNzA5IGluc2VydGlvbnMoKyksIDQ2MDAgZGVsZXRpb25zKC0pCgo= --===============2654689000911749461==--