Re: Adding a stored generated column without long-lived locks

From: Alberto Piai <alberto(dot)piai(at)gmail(dot)com>
To: Alberto Piai <alberto(dot)piai(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers(at)postgresql(dot)org
Cc: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Subject: Re: Adding a stored generated column without long-lived locks
Date: 2026-09-16 17:02:05
Message-ID: DLGVZTSLAPS8.39J305UANRWN@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
v11-0001-Support-changing-a-column-into-a-stored-generate.patch text/plain 68.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2026-09-16 17:02:50 Re: [PATCH] Release replication slot on error in SQL-callable slot functions
Previous Message Antonin Houska 2026-09-16 16:59:09 Re: REPACK enhancements