Horton

Fix FOR PORTION OF with non-updatable view columns

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 7ca8c9429675b34600e679525da6b5280c1cafa5
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2026-05-13T11:44:28Z
Releases: 19 (unreleased) 
Fix FOR PORTION OF with non-updatable view columns

Both UPDATE and DELETE were failing to test that the application-time
column was updatable.  The column is not part of
perminfo->updatedCols, because it should not be checked for
permissions.  And it needs to be checked in the DELETE case as well,
since we might insert leftovers with a value for that column.

Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Co-authored-by: jian he <jian.universality@gmail.com>
Discussion: https://www.postgresql.org/message-id/CACJufxFRqg8%3DgbZ-Q6ZS_UQ%2BYdwfZpk%2B9rf7jgWrk8m4RMUm%3DA%40mail.gmail.com

Files

PathChange+/−
src/backend/rewrite/rewriteHandler.c modified +47 −0
src/test/regress/expected/updatable_views.out modified +14 −0
src/test/regress/sql/updatable_views.sql modified +11 −0

Discussion