Re: Adding a stored generated column without long-lived locks - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Adding a stored generated column without long-lived locks
Date
Msg-id f2d93a4aabc2737ecb933d4f33b0739e9921e71b.camel@cybertec.at
Whole thread
In response to Re: Adding a stored generated column without long-lived locks  ("Alberto Piai" <alberto.piai@gmail.com>)
List pgsql-hackers
On Thu, 2026-09-24 at 00:19 +0200, Alberto Piai wrote:
> I find Matthias' proposal of exposing a function to check image equality
> very compelling for the purpose of this patch: besides fixing this
> problem, it would also make the command usable for data types which
> don't define = (json), as well as those which don't (can't?) define
> equalimage()... jsonb, numeric but also tsvector and PostGIS geometry.

True, "tsvector" is limiting; I can see people wanting that for
generated columns.

Yours,
Laurenz Albe



pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: PG19: two RI fast-path issues found while testing the batching revert
Next
From: Antonin Houska
Date:
Subject: Re: REPACK enhancements