diff options
| author | Bruce Momjian | 2018-05-28 17:16:02 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2018-05-28 17:16:02 +0000 |
| commit | 929c0dc513c13bdf287b04c094db10357eb72a23 (patch) | |
| tree | 7351b5906a28eec97d79a0bfda3834e8cc89e372 /doc/src | |
| parent | 004293c666516065033c8eeb5f1d363c0a9542dd (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> |