Re: [HACKERS] [PATCH] Lockable views

Tatsuo Ishii <ishii@sraoss.co.jp>

From: Tatsuo Ishii <ishii@sraoss.co.jp>
To: nagata@sraoss.co.jp
Cc: robertmhaas@gmail.com, ishii@sraoss.co.jp, thomas.munro@enterprisedb.com, pgsql-hackers@postgresql.org
Date: 2018-03-28T06:41:24Z
Lists: pgsql-hackers
> On Tue, 27 Mar 2018 23:28:04 +0900
> Yugo Nagata <nagata@sraoss.co.jp> wrote:
> 
> I found the previous patch was broken and this can't handle
> views that has subqueries as bellow;
> 
>  CREATE VIEW lock_view6 AS SELECT * from (select * from lock_tbl1) sub;
> 
> I fixed this and attached the updated version including additional tests.

This patch gives a warning while compiling:

lockcmds.c:186:1: warning: no semicolon at end of struct or union
 } LockViewRecurse_context;
 ^

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


Commits

  1. Allow to lock views.