diff options
author | Robert Haas <rhaas@postgresql.org> | 2011-06-14 11:05:54 -0400 |
---|---|---|
committer | Robert Haas <rhaas@postgresql.org> | 2011-06-14 11:07:18 -0400 |
commit | c3ad1e8dbd6cf1ff6d29bd2edb2da2c35187e768 (patch) | |
tree | fb3dc7b1ed5269dec385288815907ae2459d128e | |
parent | 85ea93384ae21ff59f5e5b292884a86f9c10b852 (diff) | |
download | postgresql-c3ad1e8dbd6cf1ff6d29bd2edb2da2c35187e768.tar.gz postgresql-c3ad1e8dbd6cf1ff6d29bd2edb2da2c35187e768.zip |
Improve accuracy of ON_ERROR_STOP documentation.
Per a gripe from Tom Lane.
-rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 22 |
1 files changed, 10 insertions, 12 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index eaf901d328d..d77a1aa8f53 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -2770,18 +2770,16 @@ bar <term><varname>ON_ERROR_STOP</varname></term> <listitem> <para> - By default, if non-interactive scripts encounter an error, such - as a malformed <acronym>SQL</acronym> command or internal - meta-command, processing continues. This has been the - traditional behavior of <application>psql</application> but it - is sometimes not desirable. If this variable is set, script - processing will immediately terminate. If the script was called - from another script it will terminate in the same fashion. If - the outermost script was not called from an interactive - <application>psql</application> session but rather using the - <option>-f</option> option, <application>psql</application> will - return error code 3, to distinguish this case from fatal error - conditions (error code 1). + By default, command processing continues after an error. When this + variale is set, it will instead stop immediately. In interactive mode, + <application>psql</application> will return to the command prompt; + otherwise, <application>psql</application> will exit, returning + error code 3 to distinguish this case from fatal error + conditions, which are reported using error code 1. In either case, + any currently running scripts (the toplevel script, if any, and any + other scripts which it may have in invoked) will be terminated + immediately. If the toplevel command string contained multiple SQL + commands, processing will stop with the current command. </para> </listitem> </varlistentry> |