Re: [HACKERS] [PATCH] Lockable views

From: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
To: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
Cc: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, 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-29 11:25:50
Message-ID: 20180129202550.93896457.nagata@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 26 Jan 2018 21:30:49 +0900
Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp> wrote:

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

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(at)sraoss(dot)co(dot)jp>
>

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

Attachment Content-Type Size
lock_view-v5.patch text/x-diff 22.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ildus Kurbangaliev 2018-01-29 11:44:52 Re: [HACKERS] Custom compression methods
Previous Message Kyotaro HORIGUCHI 2018-01-29 10:40:23 Re: [HACKERS] Restricting maximum keep segments by repslots