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.96) (envelope-from ) id 1x6t1X-000V5o-05 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2026 17:02:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x6t1W-008hGb-10 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2026 17:02:18 +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.96) (envelope-from ) id 1x6t1V-008hG5-22 for pgsql-hackers@lists.postgresql.org; Wed, 16 Sep 2026 17:02:18 +0000 Received: from mail-wr2-x10.google.com ([2a00:1450:4864:30::10]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x6t1Q-00000000QPp-3FOP for pgsql-hackers@postgresql.org; Wed, 16 Sep 2026 17:02:16 +0000 Received: by mail-wr2-x10.google.com with SMTP id ffacd0b85a97d-485933b2522so782907f8f.0 for ; Wed, 16 Sep 2026 10:02:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1789578131; x=1790182931; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :content-type:mime-version:references:message-id:subject:cc:to:from :date:from:to:cc:subject:date:message-id:reply-to:content-type; bh=K0tv+UPzFr6KCV2Ir1oZGiuq6EiWJOmS4iBGTtgHoKc=; b=jfLjFs03Jbjz094XgDXjhU6JTXyohEwuwh7yZ52CmcX8ukxJZSTziboVUUMCrkBoRe i4vcM37+WU38NkHkFkbTPjD7KJh3PIE25zyimyS+xkJ7x002QUnEKe2PKSkzeBdwGb+Y b/JQFkmKcr8vKh+tRLo2JTyOg5kshwQrZepqV6wwPuSzRRfhINYCp4lWLFyCtoFaTJWD zTCHx+FCalFV+pT1zyC7VfIcLBrHRISooKtOYIGreQ/sJr9iFLov0abqSaswPyBALvMK MHTyQ9Ton+6g4Hl/4W7LFlHyvDMm2vL1BSJAxDKX480d8IF6880CvY28l90XCo6Myy/f qSrw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1789578131; x=1790182931; h=in-reply-to:content-transfer-encoding:content-disposition :content-type:mime-version:references:message-id:subject:cc:to:from :date:x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to:content-type; bh=K0tv+UPzFr6KCV2Ir1oZGiuq6EiWJOmS4iBGTtgHoKc=; b=o36p3g+c2IqCltpC6bW/BrfGuIC/5yrH9xDYrbxVaZn80NcRp2SA++WnDX6tDEuZBc 805QcVt1OO4deJiSUeUA+uON9/O9UJTbRPh+NkVMi+5hF4GZ8HozxIgkGxOE/jZ1KIWi e7tC3btftd4HJvj2BhsOmxR/nAubafF1RKO5ziP5HYeg7Ho9L3413yVkWc8QzXAlKUBW Xsy43UHcaKCIxqV40qWAYCwVkajlQh3fULjMg9Pg18lkMK+V7oSz5TF0vD2bQE1kfcuE rjGSTLf5AKxM3A0P/xPkWwgcjegViRj8UniRVKpZX3uVCrbeihCcVt+CStMma34Y85cj nHug== X-Forwarded-Encrypted: i=1; AKwUvBwyr3eKyo0gbAtiMrS/tp15ewQ0SaVHW2JHY4bLRQR9UJokRcOTsyZ6CZv0YMG/h4pejZVdtyioktKDn32g@postgresql.org X-Gm-Message-State: AFuF++nE1WbcN/8Ij88roLaQaqNDg5/xskZnugeq5WIUqz1DotG7X5qC N0jlBmVciNez37zLy6w6w9wcNZW7La6lQZJiQD0Yq+kMeQhEUt8HutSW X-Gm-Gg: AYBFou3xD2tdmQWDkgOP5/Qwtsc8N+1nsF77tT/ZRWK7gPdtBZhjzfa6OsrLAYou7nY f4CYm/Pj6d08vTv338y/nPbioGOSn0qwFlOhkugjVAHq90MueJzVjOlcG8BCRxjUUtd+U8K1fTa 6jrSg9q29MTNCO5WvBDtYrLt8WtLHjfExS3jVeTOc7xECQWwGlzv/9kWk3wXaCBx37qXQ5HqUBz 37LA+RnmdEHDMxZTSpAFjynVaDZ4zb6U05WVDFnYLDJ+B1mdbtj8l9pkv91B2BBoB0gRFz3mX56 4x0uOTklUvYVWdLb2DmGZr4UqE/YcXhONXeAhKUFBnqnmNPaoRev8uM3t2mICTQPKLRJ89Snkks +gbh1BG1ox16liIqBmqO3VdgMSBnY0LRjxkaA1V2ZpNQB/zvKzibh2GyRblHjXSOtO/9Gx+oheQ UfVOEGt/CeU1YsGa0HQt9hwTdIt717gredMBw0i9icuGc29ko+ZQiTlQYNwZMJ4Sb6gXyE8KR8M RpgDO5x2mf7rJrIIqvT910gQBRZKtxz5rXfwtH3stUVDHUHVdmMDw== X-Received: by 2002:a05:6000:989:b0:487:1413:c643 with SMTP id ffacd0b85a97d-4871413c735mr253279f8f.29.1789578131133; Wed, 16 Sep 2026 10:02:11 -0700 (PDT) Received: from localhost (node-6iumophziqp2n.sensational.ch. [2a02:168:9616:1:acfb:97e4:c6f9:f6f]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-4870bf27c65sm8434150f8f.21.2026.09.16.10.02.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 16 Sep 2026 10:02:10 -0700 (PDT) Date: Wed, 16 Sep 2026 19:02:05 +0200 From: Alberto Piai To: Alberto Piai , Laurenz Albe , pgsql-hackers@postgresql.org Cc: =?utf-8?Q?=C3=81lvaro?= Herrera Subject: Re: Adding a stored generated column without long-lived locks Message-ID: X-Mailer: aerc 0.21.0 References: <6f5ea02f6e5205a96a9b3979190a4d7cb3c99414.camel@cybertec.at> <86a9336dc25d9a085916ad247a5791dc53d2ab13.camel@cybertec.at> <57bd5c0e2b532c07a1e6cd867520e899b1007622.camel@cybertec.at> <31fec16020bdf25d4a62cbbb4b8ea00af007e0d9.camel@cybertec.at> <82554bb40f6822bebbda7fcbc5ec1dc6a1823c0d.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="n5oua6etebivxsms" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --n5oua6etebivxsms Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit CFBot alerted me that a rebase was needed, so here it is in the attached v11. I also fixed a couple broken / duplicated tests that had eluded me in my last pass over this, and shortened the wording in this error message a bit: ERROR: cannot convert column "b" to generated -DETAIL: Column "b" of relation "t2" is a serial column (depends on sequence "sequence tgen.t2_b_seq"). +DETAIL: Column "b" of relation "t2" is a serial column (depends on "sequence tgen.t2_b_seq"). Kind regards, Alberto -- Alberto Piai Sensational AG Zürich, Switzerland --n5oua6etebivxsms Content-Type: text/plain; charset=utf-8 Content-Disposition: attachment; filename="v11-0001-Support-changing-a-column-into-a-stored-generate.patch"