agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Alberto Piai <alberto.piai@gmail.com>
To: Alberto Piai <alberto.piai@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
To: pgsql-hackers@postgresql.org
Cc: Álvaro Herrera <alvherre@kurilemu.de>
Subject: Re: Adding a stored generated column without long-lived locks
Date: Wed, 16 Sep 2026 19:02:05 +0200
Message-ID: <DLGVZTSLAPS8.39J305UANRWN@gmail.com> (raw)
In-Reply-To: <DL3CJBUV86UG.3IZJ0KV63YKZ2@gmail.com>
References: <6f5ea02f6e5205a96a9b3979190a4d7cb3c99414.camel@cybertec.at>
<DKXFEG915LK8.12HECZQW2OWQE@gmail.com>
<86a9336dc25d9a085916ad247a5791dc53d2ab13.camel@cybertec.at>
<DKY5OJ1NSSGO.3U2FKRKCHM533@gmail.com>
<57bd5c0e2b532c07a1e6cd867520e899b1007622.camel@cybertec.at>
<DL0C8TG99HCO.1XVPKG2IM0C1S@gmail.com>
<31fec16020bdf25d4a62cbbb4b8ea00af007e0d9.camel@cybertec.at>
<DL0PFQ4CM3KO.38HQUI04TKPLT@gmail.com>
<82554bb40f6822bebbda7fcbc5ec1dc6a1823c0d.camel@cybertec.at>
<DL3CJBUV86UG.3IZJ0KV63YKZ2@gmail.com>
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
Attachments:
[text/plain] v11-0001-Support-changing-a-column-into-a-stored-generate.patch (0B, ../DLGVZTSLAPS8.39J305UANRWN@gmail.com/2-v11-0001-Support-changing-a-column-into-a-stored-generate.patch)
download
view thread (36+ messages) latest in thread
Message-ID: <DLGVZTSLAPS8.39J305UANRWN@gmail.com>
Permalink: ../DLGVZTSLAPS8.39J305UANRWN@gmail.com/
Also on: postgresql.org/message-id/DLGVZTSLAPS8.39J305UANRWN@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alberto.piai@gmail.com, laurenz.albe@cybertec.at, alvherre@kurilemu.de
Subject: Re: Adding a stored generated column without long-lived locks
In-Reply-To: <DLGVZTSLAPS8.39J305UANRWN@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox