diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-05-26 04:08:32 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-05-26 04:08:32 +0000 |
| commit | dabde323b2cc7058946e08dbf2e56cad7601e34e (patch) | |
| tree | 54417fe06759c9f36f8881a1ce4ff6810bb3664d /doc/src | |
| parent | 4c862b18f977bbf7557cbf5a668c68f6f81734c0 (diff) | |
| download | postgresql-dabde323b2cc7058946e08dbf2e56cad7601e34e.tar.gz postgresql-dabde323b2cc7058946e08dbf2e56cad7601e34e.zip | |
Back out SQLSTATE and SQLERRM support.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 15 |
1 files changed, 7 insertions, 8 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 17e62744c5e..7d2b37e41d7 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.68 2005/05/26 00:16:31 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.69 2005/05/26 04:08:31 momjian Exp $ --> <chapter id="plpgsql"> @@ -2007,13 +2007,12 @@ END LOOP; </indexterm> <para> - Any error occurring in <application>PL/pgSQL</> sets variables - <varname>SQLSTATE</> and <varname>SQLERRM</>, and, by default, - aborts execution of the function, and indeed of the surrounding - transaction as well. You can trap errors and recover from them by - using a <command>BEGIN</> block with an <literal>EXCEPTION</> - clause. The syntax is an extension of the normal syntax for a - <command>BEGIN</> block: + By default, any error occurring in a <application>PL/pgSQL</> + function aborts execution of the function, and indeed of the + surrounding transaction as well. You can trap errors and recover + from them by using a <command>BEGIN</> block with an + <literal>EXCEPTION</> clause. The syntax is an extension of the + normal syntax for a <command>BEGIN</> block: <synopsis> <optional> <<<replaceable>label</replaceable>>> </optional> |