pgsql: Align tests for stored and virtual generated columns

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Align tests for stored and virtual generated columns
Date: 2026-03-27 14:59:26
Message-ID: E1w68ej-001i3L-2m@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Align tests for stored and virtual generated columns

These tests were intended to be aligned with each other, but
additional tests for virtual generated columns disrupted that
alignment. The test confirming that user-defined types are not
allowed in virtual generated columns has also been moved to the
generated_virtual.sql-specific section.

Author: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
Reviewed-by: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
Reviewed-by: Mutaamba Maasha <maasha(at)gmail(dot)com>
Reviewed-by: Surya Poondla <s_poondla(at)apple(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/20250808115142(dot)e9ccb81f35466a9a131a4c55(at)sraoss(dot)co(dot)jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9a9998163bda0d8c17d84ea22ced6a60f8018634

Modified Files
--------------
src/test/regress/expected/generated_stored.out | 70 ++++++++++++++++++++++++-
src/test/regress/expected/generated_virtual.out | 14 ++---
src/test/regress/sql/generated_stored.sql | 51 +++++++++++++++++-
src/test/regress/sql/generated_virtual.sql | 8 +--
4 files changed, 128 insertions(+), 15 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Nathan Bossart 2026-03-27 15:17:53 pgsql: Add rudimentary table prioritization to autovacuum.
Previous Message Peter Eisentraut 2026-03-27 13:27:28 pgsql: pgindent: Always clean up .BAK files from pg_bsd_indent