Re: [HACKERS] [PATCH] Lockable views - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] [PATCH] Lockable views
Date
Msg-id CA+TgmobPcA_d7XiXd265TgaKU1pSs6H16S4DsSG4vLL7W59gXQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] [PATCH] Lockable views  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: [HACKERS] [PATCH] Lockable views  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
On Mon, Feb 5, 2018 at 10:49 PM, Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
>> Hmm, true.  Why exactly are we imposing the restriction to updateable
>> views, anyway?
>
> In my understanding, because of ambiguity to determine which rows in
> which base tables needs to be modified by just looking at the DML
> against a view. There could be multiple ways to modify the base
> tables.

But what does that have to do with locking?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] MERGE SQL Statement for PG11
Next
From: Ashutosh Bapat
Date:
Subject: Re: Crash in partition-wise join involving dummy partitioned relation