Re: updatable view set default interact with base rel generated stored columns

2024-09-05 Thread Tom Lane
jian he writes: > --- > drop table if exists base_tbl cascade; > CREATE TABLE base_tbl (a int, b int GENERATED ALWAYS AS (22) stored, d > int default 22); > create view rw_view1 as select * from base_tbl; > insert into rw_view1(a) values (12) returning *; > alter view rw_view1

updatable view set default interact with base rel generated stored columns

2024-09-05 Thread jian he
hi. While reviewing virtual generated columns, I find some issues with the updatable view interacting with stored generated columns. --- drop table if exists base_tbl cascade; CREATE TABLE base_tbl (a int, b int GENERATED ALWAYS AS (22) stored, d int default 22); create view rw