Re: [HACKERS] [PATCH] Lockable views

From: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
To: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
Cc: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] [PATCH] Lockable views
Date: 2018-01-26 12:30:49
Message-ID: 20180126213049.8730cb04.nagata@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 25 Jan 2018 20:51:41 +1300
Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> wrote:

> On Sun, Dec 31, 2017 at 11:57 PM, Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp> wrote:
> > On Fri, 29 Dec 2017 23:39:39 +0900 (JST)
> > Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> wrote:
> >> Your addition to the doc:
> >> + Automatically updatable views (see <xref linkend="sql-createview">)
> >> + that do not have <literal>INSTEAD OF</> triggers or <literal>INSTEAD</>
> >> + rules are also lockable. When a view is locked, its base relations are
> >> + also locked recursively with the same lock mode.
> >
> > I added this point to the documentation.
>
> + Automatically updatable views (see <xref linkend="sql-createview">)
> + that do not have <literal>INSTEAD OF</> triggers or <literal>INSTEAD</>

Thank you for pointing out this.

Also, I've noticed this patch cannot be applied to the HEAD, so I'll fix
them together and update the patch.

>
> Tthe documentation doesn't build: you now need to say </literal>
> instead of </>, and you need to say <xref ... />.
>
> --
> Thomas Munro
> http://www.enterprisedb.com
>

--
Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2018-01-26 12:31:58 Re: list partition constraint shape
Previous Message Simon Riggs 2018-01-26 11:25:59 Re: [HACKERS] MERGE SQL Statement for PG11