pgsql: Resolve unknown-type literals in property expressions

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Resolve unknown-type literals in property expressions
Date: 2026-07-08 08:39:37
Message-ID: E1whNof-0007iW-0n@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Resolve unknown-type literals in property expressions

When a string literal is provided as a property expression, the data
type of the property was set to "unknown", which may lead to various
failures when the property is used in GRAPH_TABLE or when its data
type is compared against other properties with the same name. To fix
this, call resolveTargetListUnknowns() on the targetlist of new
properties being added to resolve unknown type literals.

Reported-by: Noah Misch <noah(at)leadboat(dot)com>
Author: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/20260630173053.51.noahmisch%40microsoft.com

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b820c623dd5090ef69b8b8151a0b152f5d976fed

Modified Files
--------------
src/backend/commands/propgraphcmds.c | 2 ++
.../regress/expected/create_property_graph.out | 37 +++++++++++++++++-----
src/test/regress/sql/create_property_graph.sql | 5 +++
3 files changed, 36 insertions(+), 8 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Previous Message Peter Eisentraut 2026-07-08 08:08:02 pgsql: Fix replace_property_refs() ignoring the root of expression tree