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 1wzpTv-004HVP-1r for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Aug 2026 05:50:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wzpTu-0062tE-1i for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Aug 2026 05:50:26 +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.96) (envelope-from ) id 1wzpTu-0062t0-0L for pgsql-hackers@lists.postgresql.org; Fri, 28 Aug 2026 05:50:26 +0000 Received: from mail-wr1-x432.google.com ([2a00:1450:4864:20::432]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wzpTr-00000001fpl-2Y7R for pgsql-hackers@postgresql.org; Fri, 28 Aug 2026 05:50:25 +0000 Received: by mail-wr1-x432.google.com with SMTP id ffacd0b85a97d-47fe89fb333so327997f8f.3 for ; Thu, 27 Aug 2026 22:50:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1787896221; x=1788501021; 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=OjuocVy+8eMVucgpHss6ouoGn1OD8c0zG5B6oTKvsMk=; b=nvg2smbtn9b9ybYm4lRgZUkXspaJ5XS5dSqczdP/qbLq3TJaZ0/os+o9Yuk9o3mD/b fTCnASIQ+N/1NXB7JF/GMhoBe6zezCLCr9V+siRa62CU1pI68OFwD8xiQlMG61piL8R1 655WGIBEvX+cFvZuFT/ThxxdZWIjIwf7a9sliJV4XUk2J9wufol32Z24hNkZBUESAFc+ uqIQpKDDt9Vo23xEmq92KBB/sQfi2QphGCTLHvEopgUPuViQpL4PK24znzkbPUhul6BO 6Jg3sieICGYU7jn8OnigyDAnjiHXptqAY4qQB9TmKaoVVISuQtuKIxIeRvFtZ5+UvwIj SOTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1787896221; x=1788501021; 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=OjuocVy+8eMVucgpHss6ouoGn1OD8c0zG5B6oTKvsMk=; b=lYfx2lM/hRU9+uKjCUfR+UxhjfToTiH1pjYaVSWjkA82i6qcpka1EIj5/v5qPcuPZK RHhPRGJ+6ld4zDMi3zydCcev9NCsCUwKqx9A0usK6rf+/C8O643K1M++xzJfCwVwFWCN ednSkYouKZiCjrWo0Xz1Vp5531mYWQxTGszTT4ybK3o42xWr9htgVntTpLtb2Ra860JC u83fX1UJLs4DgyYlYm10EkkU38Go/1UAd7RGFHmrN/mm2gwySBjGRU+TuwYXA2ycmbW/ 5mVXtH4ZLkizK8wC6nops0MyIztF668mNoX7IcFRjL+SLgK0UmUxo6GKtEkaP2r/h4UV a4Cg== X-Forwarded-Encrypted: i=1; AHgh+RqFOrxfU66jnQgTLRjARw8KqJbZT7IejAOWdEiBhTJI8IYE7MjRxXyMGGT5RCX87rJ0KS1NpLz6d1cv5afQ@postgresql.org X-Gm-Message-State: AFuF++kc6n9qU6gZh+1iqFwfkN6uYm3B9/n/AZjC6ipBv4YOiZJ1uxg6 AtQpuJMlW3kfSfOCiJWD3+BN+pkelNAHJ8qGv979suRRxzqNMYLXnXMD X-Gm-Gg: AR+sD12JdjeCaktrpoSbGPL64VDFxFk6REZhmnCQGOJIKAo+5B9ymLz0yLt/ZCaaIIn XTbYoqnYvokcFkmgGiTKmCxBCYYvjWHeBHp0XCwq6ai3fqWid4LyYAwUq8ghBZVGFdMcM2CbYLj PLHZqZLV45WGta+zrHN5naboUxzC+hSm+0gI6zb5dDwCRMw83UkiLbbrXWZG12cMcdP76tnyko/ 7Tzb6colBngm/GUjWD1YoZxwGp+35QRF0JGhq9sy5dFoLGpGa3D31RvRqVdk6o7M1UTA+P4YQT6 54mvMpZiUQIp/zDXHWfPvRdoxSRXdkC914Yd24nYx2EV6E6haJsntKF/NJoOiCIyfuQree5s2Zc JK+u5xEY7Epou60E6yfDrmqJicj9JN3/W1i7WUvgQaOI7N5DHcJQxwl4JJH1RYlqqObn9v4AnbW Xcl/Ri4FFciulMebaXdVx+R++k0IEQrY/X1HD3VJrga5dyhMRK4xbugUYs8m2FNA/iFwcQ+w7U/ ma4kQ== X-Received: by 2002:a05:6000:40cb:b0:482:f0dc:e647 with SMTP id ffacd0b85a97d-482f79f3328mr4424007f8f.21.1787896221246; Thu, 27 Aug 2026 22:50:21 -0700 (PDT) Received: from localhost ([2a02:169:191:0:b0ad:d4ca:cd10:184]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-482fbb284cbsm1429906f8f.30.2026.08.27.22.50.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 Aug 2026 22:50:20 -0700 (PDT) Date: Fri, 28 Aug 2026 07:50:15 +0200 From: Alberto Piai To: Laurenz Albe , Alberto Piai , 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: <2eb68e74ea95fc2f691de7d8cd28448d00d1d216.camel@cybertec.at> <79b63e772179abb4f5ad749d9e067d48a5537599.camel@cybertec.at> <6f5ea02f6e5205a96a9b3979190a4d7cb3c99414.camel@cybertec.at> <86a9336dc25d9a085916ad247a5791dc53d2ab13.camel@cybertec.at> <57bd5c0e2b532c07a1e6cd867520e899b1007622.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="euf2nhhle7fls3fd" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <57bd5c0e2b532c07a1e6cd867520e899b1007622.camel@cybertec.at> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --euf2nhhle7fls3fd Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit On Wed Aug 26, 2026 at 7:20 AM CEST, Laurenz Albe wrote: >> Since the root of the hierarchy is in both cases just a table >> (partitoned or not), what about just calling it a table? >> >>   ERROR:  cannot convert column "c" to generated >>   DETAIL:  Converting only part of a partitioning or inheritance hierarchy is not supported. >>   HINT:  Use this command on the root table without specifying ONLY. > > Both variants look fine to me. Pick the one you prefer. OK, I went with "table" then. Here's v9, rebased on top of current master. Best regards, Alberto -- Alberto Piai Sensational AG Zürich, Switzerland --euf2nhhle7fls3fd Content-Type: text/plain; charset=utf-8 Content-Disposition: attachment; filename="v9-0001-Support-changing-a-column-into-a-stored-generated.patch"