diff options
| author | Tatsuo Ishii <ishii@postgresql.org> | 2018-03-30 09:18:02 +0900 |
|---|---|---|
| committer | Tatsuo Ishii <ishii@postgresql.org> | 2018-03-30 09:18:02 +0900 |
| commit | 34c20de4d0b0ea8f96d0c518724d876c7b984cf5 (patch) | |
| tree | 1d222f2d4e3a9de6059f427cb74c817c5c9e9858 /doc/src | |
| parent | fb604780114cea6a83f3f6a60e7f51a7185c932b (diff) | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/lock.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
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 @@ -46,6 +46,11 @@ LOCK [ TABLE ] [ ONLY ] <replaceable class="parameter">name</replaceable> [ * ] </para> <para> + 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. + </para> + + <para> When acquiring locks automatically for commands that reference tables, <productname>PostgreSQL</productname> always uses the least restrictive lock mode possible. <command>LOCK TABLE</command> |