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 | c5bc95da0aae12eb24722f5d89a966a38b556913 (patch) | |
| tree | 9e171aa9665ddf0710b9794922cc6294d0ac5d6c /doc/src | |
| parent | 98d522a1de1b6c90edabbbfda0cda734286edd03 (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> |