diff options
author | Bruce Momjian <bruce@momjian.us> | 2018-05-28 13:16:02 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2018-05-28 13:16:02 -0400 |
commit | 9b5532a3c73394cefb24109662841d1634719563 (patch) | |
tree | 5894505d640b1f3e2c4947abdcb44fd3ce630777 /doc/src | |
parent | 5a225b0d61778c1912e766a8ea0b60216734b1d2 (diff) |
doc: adjust DECLARE docs to mention FOR UPDATE behavior
Reported-by: Peter Eisentraut
Discussion: https://postgr.es/m/8dc63ba7-dc56-fc7c-fc16-4fae03e3bfe6@2ndquadrant.com
Author: Peter Eisentraut, Tom Lane, me
Backpatch-through: 9.3
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/declare.sgml | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/declare.sgml b/doc/src/sgml/ref/declare.sgml index 5cb85cc568f..864c3d75f7f 100644 --- a/doc/src/sgml/ref/declare.sgml +++ b/doc/src/sgml/ref/declare.sgml @@ -271,7 +271,8 @@ DECLARE <replaceable class="parameter">name</replaceable> [ BINARY ] [ INSENSITI and not use grouping or <literal>ORDER BY</>). Cursors that are not simply updatable might work, or might not, depending on plan choice details; so in the worst case, an application might work in testing - and then fail in production. + and then fail in production. If <literal>FOR UPDATE</literal> is + specified, the cursor is guaranteed to be updatable. </para> <para> |