agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Peter Eisentraut <peter@eisentraut.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Forbid generated columns in FOR PORTION OF
Date: Mon, 06 Jul 2026 07:42:03 +0000
Message-ID: <E1wgdxr-001You-1Q@gemulon.postgresql.org> (raw)
Forbid generated columns in FOR PORTION OF
With virtual generated columns there is no column to assign to, and we
shouldn't assign directly to stored generated columns either. (Once
we have PERIODs, we will allow a stored generated column here, but we
will assign to its start/end inputs.)
We can't do this in parse analysis, because views haven't yet been
rewritten, so they mask generated columns.
Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Discussion: https://www.postgresql.org/message-id/agOOykf2HV26yVfU%40nathan
Branch
------
REL_19_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/c8d49ffb007b2f5aff61cff2ff68786f2d53ac5d
Modified Files
--------------
doc/src/sgml/ddl.sgml | 4 +-
src/backend/optimizer/plan/planner.c | 26 ++++++++++
src/test/regress/expected/for_portion_of.out | 73 ++++++++++++++++++++++++++++
src/test/regress/sql/for_portion_of.sql | 57 ++++++++++++++++++++++
4 files changed, 159 insertions(+), 1 deletion(-)
view thread (2+ messages)
Message-ID: <E1wgdxr-001You-1Q@gemulon.postgresql.org>
Permalink: ../E1wgdxr-001You-1Q@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1wgdxr-001You-1Q@gemulon.postgresql.org
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-committers@postgresql.org
Cc: peter@eisentraut.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Forbid generated columns in FOR PORTION OF
In-Reply-To: <E1wgdxr-001You-1Q@gemulon.postgresql.org>
* 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