Horton
Menu

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

Alberto Piai <alberto.piai@gmail.com>

View thread
From: Alberto Piai <alberto.piai@gmail.com>
To: Alberto Piai <alberto.piai@gmail.com>, pgsql-hackers@postgresql.org
Date: 2026-04-24T09:10:22Z
Lists: pgsql-hackers

Attachments

On Tue Apr 7, 2026 at 5:02 PM +08, Alberto Piai wrote:
> On Tue Mar 17, 2026 at 5:31 PM +07, Alberto Piai wrote:
>
>> I recently needed to add a stored generated column to a table of
>> nontrivial size, and realized that currently there is no way to do
>> that without rewriting the table under an AccessExclusiveLock.

Attached v3, just a rebase onto current master.

Regards,

Alberto

-- 
Alberto Piai
Sensational AG
Zürich, Switzerland

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Improve handling of inherited GENERATED expressions.