bug: UPDATE FOR PORTION OF interact with updatable view

hi.

CREATE TABLE base_tbl (a int, b int, c int);
INSERT INTO base_tbl values(1,2);
CREATE VIEW rw_view15 AS SELECT a, ('[' || abs(b) ||
',20]')::int4range as b FROM base_tbl;

UPDATE rw_view15 for portion of b from 1 to 10 set a = 2;
DELETE FROM rw_view15 for portion of b from 1 to 10;

The UPDATE will result
ERROR:  attribute number 2 not found in view targetlist

\errverbose
ERROR:  XX000: attribute number 2 not found in view targetlist
LOCATION:  rewriteTargetView, rewriteHandler.c:3779

The DELETE will crash the server.

Both should result in an error in rewriteTargetView.
for UPDATE, the error message:
ERROR:  cannot update column "b" of view "rw_view15"
DETAIL:  View columns that are not columns of their base relation are
not updatable.

for DELETE, the error message:
ERROR:  DELETE ... FOR PORTION OF is not supported for column "b" on
view "rw_view15"
DETAIL:  View columns that are not columns of their base relation are
not updatable.

Later, I will add this to
https://wiki.postgresql.org/wiki/PostgreSQL_19_Open_Items



--
jian
https://www.enterprisedb.com/