Hi Oliver, > On 05. Aug, 2020, at 20:30, Wells Oliver <wells.oliver@xxxxxxxxx> wrote: > > Err, sorry if this is back to basics, but I was very confused by someone being able to UPDATE myview SET col = 1 and the underlying table actually being updated properly. > > Is this recent? When did we become able to UPDATE on views? yes, this is possible: postgres=# create table t(i int); CREATE TABLE postgres=# create view v(i) as select i from t; CREATE VIEW postgres=# insert into v(i) values (0); INSERT 0 1 postgres=# select * from v; i --- 0 (1 row) postgres=# update v set i=3; UPDATE 1 postgres=# select * from v; i --- 3 (1 row) But I don't know since which PostgreSQL version views can up updated. Cheers, Paul
