Re: Show expression of virtual columns in error messages

From: Matheus Alcantara <matheusssilv97(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, Peter Eisentraut <peter(at)eisentraut(dot)org>, Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
Subject: Re: Show expression of virtual columns in error messages
Date: 2026-03-16 15:36:34
Message-ID: 68dcb0b5-1c0b-41ed-b2eb-bbb12c3ea5f3@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 03/03/26 14:01, I wrote:
> Please see the attached patch where I implement this. I followed a
> similar pattern used for stored generated columns with some small
> changes. Some special handling for virtual columns was removed but I
> still left some comments but I'm not sure if it's really needed.
>
> With this change I think that doc/src/sgml/ddl.sgml should be updated
> to mention that a virtual generated column expression is also
> evaluated when writing the data ...
>

Attaching v5 with documentation changes included and rebased with master.

--
Matheus Alcantara
EDB: https://www.enterprisedb.com

Attachment Content-Type Size
v5-0001-Compute-virtual-generated-columns-during-INSERT-U.patch text/plain 25.5 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2026-03-16 15:49:36 Re: Adding REPACK [concurrently]
Previous Message Tom Lane 2026-03-16 15:32:15 Re: Change copyObject() to use typeof_unqual