On Mon, Feb 5, 2018 at 10:26 PM, Tatsuo Ishii <is...@sraoss.co.jp> wrote: >> True. But the same exact analysis also applies to this definition, >> which contains no subquery: >> >> CREATE VIEW v1 AS SELECT t1.* FROM t1, t2 WHERE t1.i = t2.i; > > That's not an updatable view, thus cannot be locked according to the > proposed implementation.
Hmm, true. Why exactly are we imposing the restriction to updateable views, anyway? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company