Re: [HACKERS] [PATCH] Lockable views

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: robertmhaas(at)gmail(dot)com
Cc: ishii(at)sraoss(dot)co(dot)jp, thomas(dot)munro(at)enterprisedb(dot)com, nagata(at)sraoss(dot)co(dot)jp, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] [PATCH] Lockable views
Date: 2018-02-06 03:49:36
Message-ID: 20180206.124936.1308836747400108762.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2018-02-06 03:56:39 Re: [HACKERS] MERGE SQL Statement for PG11
Previous Message Robert Haas 2018-02-06 03:49:29 Re: [HACKERS] MERGE SQL Statement for PG11