From 34c20de4d0b0ea8f96d0c518724d876c7b984cf5 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Fri, 30 Mar 2018 09:18:02 +0900 Subject: Allow to lock views. Now all tables used in view definitions can be recursively locked by a LOCK command. Author: Yugo Nagata Reviewed by Robert Haas, Thomas Munro and me. Discussion: https://postgr.es/m/20171011183629.eb2817b3.nagata%40sraoss.co.jp --- doc/src/sgml/ref/lock.sgml | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index b2c72039195..96d477c2038 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -45,6 +45,11 @@ LOCK [ TABLE ] [ ONLY ] name [ * ] end.) + + When a view is specified to be locked, all relations appearing in the view + definition query are also locked recursively with the same lock mode. + + When acquiring locks automatically for commands that reference tables, PostgreSQL always uses the least -- cgit v1.2.3