Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.1\))
Subject: Re: UPDATE works on a view?
From: =?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>
In-Reply-To: 
 <CAOC+FBUYTaQ+Sk2tA24NdExek4_-S5q4Oe86Bx4K_6Th5F-aWQ@mail.gmail.com>
Date: Thu, 6 Aug 2020 07:56:27 +0200
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <ACCB0592-8786-4E68-8250-39ADF143BF37@gmail.com>
References: 
 <CAOC+FBUYTaQ+Sk2tA24NdExek4_-S5q4Oe86Bx4K_6Th5F-aWQ@mail.gmail.com>
To: Wells Oliver <wells.oliver@gmail.com>
Precedence: bulk

Hi Oliver,

> On 05. Aug, 2020, at 20:30, Wells Oliver <wells.oliver@gmail.com> =
wrote:
>=20
> Err, sorry if this is back to basics, but I was very confused by =
someone being able to UPDATE myview SET col =3D 1 and the underlying =
table actually being updated properly.
>=20
> Is this recent? When did we become able to UPDATE on views?

yes, this is possible:

postgres=3D# create table t(i int);
CREATE TABLE
postgres=3D# create view v(i) as select i from t;
CREATE VIEW
postgres=3D# insert into v(i) values (0);
INSERT 0 1
postgres=3D# select * from v;
 i=20
---
 0
(1 row)

postgres=3D# update v set i=3D3;
UPDATE 1
postgres=3D# select * from v;
 i=20
---
 3
(1 row)

But I don't know since which PostgreSQL version views can up updated.

Cheers,
Paul=