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 1u1q95-008uWD-2j for pgsql-committers@arkaria.postgresql.org; Mon, 07 Apr 2025 17:20:27 +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 1u1q93-001kSf-Fx for pgsql-committers@arkaria.postgresql.org; Mon, 07 Apr 2025 17:20:25 +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 1u1q93-001kSX-8d for pgsql-committers@lists.postgresql.org; Mon, 07 Apr 2025 17:20:25 +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 1u1q91-003xe7-0P for pgsql-committers@lists.postgresql.org; Mon, 07 Apr 2025 17:20:25 +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 1u1q8z-001aUM-LB for pgsql-committers@lists.postgresql.org; Mon, 07 Apr 2025 17:20:21 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u1q8z-0039ha-0U for pgsql-committers@lists.postgresql.org; Mon, 07 Apr 2025 17:20:21 +0000 Content-Type: multipart/mixed; boundary="===============7001660174252650762==" MIME-Version: 1.0 From: =?utf-8?q?=C3=81lvaro_Herrera?= To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow NOT NULL constraints to be added as NOT VALID X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 07 Apr 2025 17:20:21 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7001660174252650762== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgTk9UIE5VTEwgY29uc3RyYWludHMgdG8gYmUgYWRkZWQgYXMgTk9UIFZBTElECgpUaGlz IGFsbG93cyB0aGVtIHRvIGJlIGFkZGVkIHdpdGhvdXQgc2Nhbm5pbmcgdGhlIHRhYmxlLCBhbmQg dmFsaWRhdGluZwp0aGVtIGFmdGVyd2FyZHMgd2l0aG91dCBob2xkaW5nIGFjY2VzcyBleGNsdXNp dmUgbG9jayBvbiB0aGUgdGFibGUgYWZ0ZXIKYW55IHZpb2xhdGluZyByb3dzIGhhdmUgYmVlbiBk ZWxldGVkIG9yIGZpeGVkLgoKRG9pbmcgQUxURVIgVEFCTEUgLi4uIFNFVCBOT1QgTlVMTCBmb3Ig YSBjb2x1bW4gdGhhdCBoYXMgYW4gaW52YWxpZApub3QtbnVsbCBjb25zdHJhaW50IHZhbGlkYXRl cyB0aGF0IGNvbnN0cmFpbnQuICBBTFRFUiBUQUJMRSAuLiBWQUxJREFURQpDT05TVFJBSU5UIGlz IGFsc28gc3VwcG9ydGVkLiAgVGhlcmUgYXJlIHZhcmlvdXMgY2hlY2tzIG9uIHdoZXRoZXIgYW4K aW52YWxpZCBjb25zdHJhaW50IGlzIGFsbG93ZWQgaW4gYSBjaGlsZCB0YWJsZSB3aGVuIHRoZSBw YXJlbnQgdGFibGUgaGFzCmEgdmFsaWQgY29uc3RyYWludDsgdGhpcyBzaG91bGQgbWF0Y2ggd2hh dCB3ZSBkbyBmb3IgZW5mb3JjZWQvbm90CmVuZm9yY2VkIGNvbnN0cmFpbnRzLgoKcGdfYXR0cmli dXRlLmF0dG5vdG51bGwgaXMgbm93IG9ubHkgYW4gaW5kaWNhdG9yIGZvciB3aGV0aGVyIGEgbm90 LW51bGwKY29uc3RyYWludCBleGlzdHMgZm9yIHRoZSBjb2x1bW47IHdoZXRoZXIgaXQncyB2YWxp ZCBvciBpbnZhbGlkIG11c3QgYmUKcXVlcmllZCBpbiBwZ19jb25zdHJhaW50LiAgQXBwbGljYXRp b25zIGNhbiBjb250aW51ZSB0byBxdWVyeQpwZ19hdHRyaWJ1dGUuYXR0bm90bnVsbCBhcyBiZWZv cmUsIGJ1dCBub3cgaXQncyBwb3NzaWJsZSB0aGF0IE5VTEwgcm93cwphcmUgcHJlc2VudCBpbiB0 aGUgY29sdW1uIGV2ZW4gd2hlbiB0aGF0J3Mgc2V0IHRvIHRydWUuCgpGb3IgYmFja2VuZCBpbnRl cm5hbCBwdXJwb3Nlcywgd2UgY2FjaGUgdGhlIG51bGxhYmlsaXR5IHN0YXR1cyBpbgpDb21wYWN0 QXR0cmlidXRlLT5hdHRudWxsYWJpbGl0eSB0aGF0IGVhY2ggdHVwbGUgZGVzY3JpcHRvciBjYXJy aWVzCihyZXBsYWNpbmcgQ29tcGFjdEF0dHJpYnV0ZS5hdHRub3RudWxsLCB3aGljaCB3YXMgYSBt aXJyb3Igb2YKRm9ybV9wZ19hdHRyaWJ1dGUuYXR0bm90bnVsbCkuICBEdXJpbmcgdGhlIGluaXRp YWwgdHVwbGUgZGVzY3JpcHRvcgpjcmVhdGlvbiwgYmFzZWQgb24gdGhlIHBnX2F0dHJpYnV0ZSBz Y2FuLCB3ZSBzZXQgdGhpcyB0byBVTlJFU1RSSUNURUQgaWYKcGdfYXR0cmlidXRlLmF0dG5vdG51 bGwgaXMgZmFsc2UsIG9yIHRvIFVOS05PV04gaWYgaXQncyB0cnVlOyB0aGVuIHdlCnVwZGF0ZSB0 aGUgbGF0dGVyIHRvIFZBTElEIG9yIElOVkFMSUQgZGVwZW5kaW5nIG9uIHRoZSBwZ19jb25zdHJh aW50CnNjYW4uICBUaGlzIGZsYWcgaXMgYWxzbyBjb3BpZWQgd2hlbiB0dXBsZWRlc2NzIGFyZSBj b3BpZWQuCgpDb21wYXJpbmcgdHVwbGUgZGVzY3MgZm9yIGVxdWFsaXR5IG11c3QgYWxzbyBjb21w YXJlIHRoZQpDb21wYWN0QXR0cmlidXRlLmF0dG51bGxhYmlsaXR5IGZsYWcgYW5kIHJldHVybiBm YWxzZSBpbiBjYXNlIG9mIGEKbWlzbWF0Y2guCgpwZ19kdW1wIGRlYWxzIHdpdGggdGhlc2UgY29u c3RyYWludHMgYnkgc3RvcmluZyB0aGUgT0lEcyBvZiBpbnZhbGlkCm5vdC1udWxsIGNvbnN0cmFp bnRzIGluIGEgc2VwYXJhdGUgYXJyYXksIGFuZCBydW5uaW5nIGEgcXVlcnkgdG8gb2J0YWluCnRo ZWlyIHByb3BlcnRpZXMuICBUaGUgcmVndWxhciB0YWJsZSBjcmVhdGlvbiBTUUwgb21pdHMgdGhl bSBlbnRpcmVseS4KVGhleSBhcmUgdGhlbiBkZWFsdCB3aXRoIGluIHRoZSBzYW1lIHdheSBhcyAi c2VwYXJhdGUiIENIRUNLCmNvbnN0cmFpbnRzLCBhbmQgZHVtcGVkIGFmdGVyIHRoZSBkYXRhIGhh cyBiZWVuIGxvYWRlZC4gIEJlY2F1c2Ugbm8KYWRkaXRpb25hbCBwZ19kdW1wIGluZnJhc3RydWN0 dXJlIHdhcyByZXF1aXJlZCwgd2UgZG9uJ3QgYnVtcCBpdHMKdmVyc2lvbiBudW1iZXIuCgpJIGRl Y2lkZWQgbm90IHRvIGJ1bXAgY2F0dmVyc2lvbiBlaXRoZXIsIGJlY2F1c2UgdGhlIG9sZCBjYXRh bG9nIHN0YXRlCndvcmtzIHBlcmZlY3RseSBpbiB0aGUgbmV3IHdvcmxkLiAgKFRyeWluZyB0byBy dW4gd2l0aCBuZXcgY2F0YWxvZyBzdGF0ZQphbmQgdGhlIG9sZCBzZXJ2ZXIgdmVyc2lvbiB3b3Vs ZCBsaWtlbHkgcnVuIGludG8gaXNzdWVzLCBob3dldmVyLikKClN5c3RlbSBjYXRhbG9ncyBkbyBu b3Qgc3VwcG9ydCBpbnZhbGlkIG5vdC1udWxsIGNvbnN0cmFpbnRzIChiZWNhdXNlCmNvbW1pdCAx NGU4N2ZmYTVjNTQgZGlkbid0IGFsbG93IHRoZW0gdG8gaGF2ZSBwZ19jb25zdHJhaW50IHJvd3MK YW55d2F5LikKCkF1dGhvcjogUnVzaGFiaCBMYXRoaWEgPHJ1c2hhYmgubGF0aGlhQGdtYWlsLmNv bT4KQXV0aG9yOiBKaWFuIEhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+ClJldmlld2Vk LWJ5OiDDgWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGFsdmgubm8taXAub3JnPgpUZXN0ZWQtYnk6 IEFzaHV0b3NoIEJhcGF0IDxhc2h1dG9zaC5iYXBhdC5vc3NAZ21haWwuY29tPgpEaXNjdXNzaW9u OiBodHRwczovL3Bvc3Rnci5lcy9tL0NBR1BxUWYwS2l0a05hY2s0RjVDRmtGaS05RHF2cDI5Um89 RXBjV3Q9NF9ocy1SdCtiUUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRl dGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2Ez NzkwNjFhMjJhOGZkZjQyMWUxYTQ1N2NjNmFmODUwM2RlZjYyNTIKCk1vZGlmaWVkIEZpbGVzCi0t LS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgIHwg ICAyICstCmRvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbCAgICAgICAgIHwgICA4ICst CnNyYy9iYWNrZW5kL2FjY2Vzcy9jb21tb24vdHVwZGVzYy5jICAgICAgIHwgIDM4ICsrKystCnNy Yy9iYWNrZW5kL2NhdGFsb2cvaGVhcC5jICAgICAgICAgICAgICAgIHwgICA5ICstCnNyYy9iYWNr ZW5kL2NhdGFsb2cvcGdfY29uc3RyYWludC5jICAgICAgIHwgIDQ2ICsrKy0tCnNyYy9iYWNrZW5k L2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgIHwgMjcxICsrKysrKysrKysrKysrKysrKysr KysrKystLS0tLQpzcmMvYmFja2VuZC9qaXQvbGx2bS9sbHZtaml0X2RlZm9ybS5jICAgICB8ICAx MCArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9wbGFuY2F0LmMgICAgICB8ICAxNiArLQpz cmMvYmFja2VuZC9wYXJzZXIvZ3JhbS55ICAgICAgICAgICAgICAgICB8ICAgNSArLQpzcmMvYmFj a2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5jICAgICAgICB8ICA3MyArKysrKysrLQpzcmMvYmlu L3BnX2R1bXAvcGdfZHVtcC5jICAgICAgICAgICAgICAgICB8IDE5MCArKysrKysrKysrKysrKysr KysrLS0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuaCAgICAgICAgICAgICAgICAgfCAgIDIgKwpz cmMvYmluL3BnX2R1bXAvdC8wMDJfcGdfZHVtcC5wbCAgICAgICAgICB8ICAyMSArKy0Kc3JjL2Jp bi9wc3FsL2Rlc2NyaWJlLmMgICAgICAgICAgICAgICAgICAgfCAgIDkgKy0Kc3JjL2luY2x1ZGUv YWNjZXNzL3R1cGRlc2MuaCAgICAgICAgICAgICAgfCAgMTAgKy0Kc3JjL2luY2x1ZGUvY2F0YWxv Zy9wZ19hdHRyaWJ1dGUuaCAgICAgICAgfCAgIDQgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19j b25zdHJhaW50LmggICAgICAgfCAgIDIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9hbHRl cl90YWJsZS5vdXQgfCAgNjkgKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jb25z dHJhaW50cy5vdXQgfCAyNTIgKysrKysrKysrKysrKysrKysrKysrKysrKysrCnNyYy90ZXN0L3Jl Z3Jlc3Mvc3FsL2FsdGVyX3RhYmxlLnNxbCAgICAgIHwgIDE0ICsrCnNyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2NvbnN0cmFpbnRzLnNxbCAgICAgIHwgMTY5ICsrKysrKysrKysrKysrKysrKysKMjEgZmls ZXMgY2hhbmdlZCwgMTEwOSBpbnNlcnRpb25zKCspLCAxMTEgZGVsZXRpb25zKC0pCgo= --===============7001660174252650762==--