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 1ty9EN-0032SL-4b for pgsql-committers@arkaria.postgresql.org; Fri, 28 Mar 2025 12:54:39 +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 1ty9EJ-009cmi-K0 for pgsql-committers@arkaria.postgresql.org; Fri, 28 Mar 2025 12:54:35 +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 1ty9EJ-009cma-CZ for pgsql-committers@lists.postgresql.org; Fri, 28 Mar 2025 12:54:35 +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 1ty9EG-001i0U-1m for pgsql-committers@lists.postgresql.org; Fri, 28 Mar 2025 12:54:34 +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 1ty9EE-00EC0Z-Fg for pgsql-committers@lists.postgresql.org; Fri, 28 Mar 2025 12:54:30 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ty9ED-001QT8-2f for pgsql-committers@lists.postgresql.org; Fri, 28 Mar 2025 12:54:29 +0000 Content-Type: multipart/mixed; boundary="===============7272493472181828236==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add support for not-null constraints on virtual generated column X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 28 Mar 2025 12:54:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7272493472181828236== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHN1cHBvcnQgZm9yIG5vdC1udWxsIGNvbnN0cmFpbnRzIG9uIHZpcnR1YWwgZ2VuZXJhdGVk IGNvbHVtbnMKClRoaXMgd2FzIGxlZnQgb3V0IG9mIHRoZSBvcmlnaW5hbCBwYXRjaCBmb3Igdmly dHVhbCBnZW5lcmF0ZWQgY29sdW1ucwooY29tbWl0IDgzZWE2YzU0MDI1KS4KClRoaXMganVzdCBp bnZvbHZlcyBhIGJpdCBvZiBleHRyYSB3b3JrIGluIHRoZSBleGVjdXRvciB0byBleHBhbmQgdGhl CmdlbmVyYXRpb24gZXhwcmVzc2lvbnMgYW5kIHJ1biBhICJJUyBOT1QgTlVMTCIgdGVzdCBhZ2Fp bnN0IHRoZW0uCgpUaGVyZSBpcyBhbHNvIGEgYml0IG9mIHdvcmsgdG8gbWFrZSBzdXJlIHRoYXQg bm90LW51bGwgY29uc3RyYWludHMgYXJlCmNoZWNrZWQgZHVyaW5nIGEgdGFibGUgcmV3cml0ZS4K CkF1dGhvcjogamlhbiBoZSA8amlhbi51bml2ZXJzYWxpdHlAZ21haWwuY29tPgpSZXZpZXdlZC1i eTogWHVuZW5nIFpob3UgPHh1bmVuZ3pob3VAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogTmF2bmVl dCBLdW1hciA8dGhhbml0MzExMUBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiDDgWx2YXJvIEhlcnJl cmEgPGFsdmhlcnJlQGFsdmgubm8taXAub3JnPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tL0NBQ0p1ZnhIQXJReXNiRGtXRm12SytEMVRQSFFXV1R4V04xNWNNdVVhVFlYM3hoUVhnZ0Bt YWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRw czovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2NkYzE2OGFkNGIyMmVhNDE4M2Y5 NjY2ODhiMjQ1Y2FiYjU5MzVkMWYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9i YWNrZW5kL2NhdGFsb2cvaGVhcC5jICAgICAgICAgICAgICAgICAgICAgIHwgIDEwIC0tCnNyYy9i YWNrZW5kL2NvbW1hbmRzL2luZGV4Y21kcy5jICAgICAgICAgICAgICAgIHwgIDEwICstCnNyYy9i YWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgICAgICAgIHwgIDcxICsrKysrKy0t CnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNNYWluLmMgICAgICAgICAgICAgICAgIHwgMjIwICsr KysrKysrKysrKysrKysrKy0tLS0tLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfdXRpbGNtZC5j ICAgICAgICAgICAgICB8ICAxNCAtLQpzcmMvaW5jbHVkZS9leGVjdXRvci9leGVjdXRvci5oICAg ICAgICAgICAgICAgICB8ICAgNCArCnNyYy9pbmNsdWRlL25vZGVzL2V4ZWNub2Rlcy5oICAgICAg ICAgICAgICAgICAgIHwgICA2ICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9nZW5lcmF0ZWRf dmlydHVhbC5vdXQgfCAgOTAgKysrKysrKystLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9nZW5lcmF0 ZWRfdmlydHVhbC5zcWwgICAgICB8ICA1NCArKysrKy0KOSBmaWxlcyBjaGFuZ2VkLCAzNjAgaW5z ZXJ0aW9ucygrKSwgMTE5IGRlbGV0aW9ucygtKQoK --===============7272493472181828236==--