Horton

Re: [HACKERS] [PATCH] Lockable views

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: Thomas Munro <thomas.munro@enterprisedb.com>, Yugo Nagata <nagata@sraoss.co.jp>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2018-02-06T03:40:52Z
Lists: pgsql-hackers 
On Mon, Feb 5, 2018 at 10:26 PM, Tatsuo Ishii <ishii@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

Commits

  1. Allow to lock views.