Re: [HACKERS] [PATCH] Lockable views
Yugo Nagata <nagata@sraoss.co.jp>
From: Yugo Nagata <nagata@sraoss.co.jp>
To: Yugo Nagata <nagata@sraoss.co.jp>
Cc: Thomas Munro <thomas.munro@enterprisedb.com>, Tatsuo Ishii
<ishii@sraoss.co.jp>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-01-29T11:25:50Z
Lists: pgsql-hackers
Attachments
- lock_view-v5.patch (text/x-diff) patch v5
On Fri, 26 Jan 2018 21:30:49 +0900 Yugo Nagata <nagata@sraoss.co.jp> wrote: > 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. Attached is the updated patch v5 including fixing SGML and rebase to HEAD. Regards, > > > > > 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> > -- Yugo Nagata <nagata@sraoss.co.jp>
Commits
-
Allow to lock views.
- 34c20de4d0b0 11.0 landed