Horton

expand virtual generated columns in get_relation_constraints()

Peter Eisentraut <peter@eisentraut.org>

View thread View on postgr.es
From: Peter Eisentraut <peter@eisentraut.org>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-09-03T14:05:09Z
Lists: pgsql-hackers

Attachments

We (I) missed expanding virtual generated columns in 
get_relation_constraints() in plancat.c.  That way, some opportunities 
for constraint exclusion will be missed if a constraint contains virtual 
generated columns, as can be shown in the attached test case (thanks to 
Richard Guo).  Simple fix attached.

Commits

  1. Expand virtual generated columns in constraint expressions