Re: [HACKERS] [PATCH] Lockable views

Yugo Nagata <nagata@sraoss.co.jp>

From: Yugo Nagata <nagata@sraoss.co.jp>
To: Thomas Munro <thomas.munro@enterprisedb.com>
Cc: Tatsuo Ishii <ishii@sraoss.co.jp>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-01-26T12:30:49Z
Lists: pgsql-hackers
On Thu, 25 Jan 2018 20:51:41 +1300
Thomas Munro <thomas.munro@enterprisedb.com> wrote:

> On Sun, Dec 31, 2017 at 11:57 PM, Yugo Nagata <nagata@sraoss.co.jp> wrote:
> > On Fri, 29 Dec 2017 23:39:39 +0900 (JST)
> > Tatsuo Ishii <ishii@sraoss.co.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@sraoss.co.jp>


Commits

  1. Allow to lock views.