Home > mailing lists

UPDATE works on a view? - Mailing list pgsql-admin

From	Wells Oliver
Subject	UPDATE works on a view?
Date	August 5, 2020 21:30:46
Msg-id	CAOC+FBUYTaQ+Sk2tA24NdExek4_-S5q4Oe86Bx4K_6Th5F-aWQ@mail.gmail.com Whole thread Raw
Responses	Re: UPDATE works on a view? (Tom Lane <tgl@sss.pgh.pa.us>) Re: UPDATE works on a view? (Paul Förster <paul.foerster@gmail.com>)
List	pgsql-admin

Tree view

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?

Wells Oliver
wells.oliver@gmail.com

pgsql-admin by date:

From: Keith Fiske
Date: 05 August 2020, 17:25:40
Subject: Re: How can i be certain autovacuum is causing reuse if table still grows

From: Tom Lane
Date: 05 August 2020, 21:42:42
Subject: Re: UPDATE works on a view?

UPDATE works on a view? - Mailing list pgsql-admin

Previous

Next