From 17df2a8b3946895c78f4ca088804341172ef27ae Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 22 Aug 2018 15:42:22 +0200 Subject: [PATCH] doc: Clarify some wording in PL/pgSQL about transactions Some text was still claiming that committing transactions was not possible in PL/pgSQL. --- doc/src/sgml/plpgsql.sgml | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 6b19f18dd8..e80b57bb3d 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -305,10 +305,9 @@ $$ LANGUAGE plpgsql; for transaction control. PL/pgSQL's BEGIN/END are only for grouping; they do not start or end a transaction. - Functions are always executed within a transaction - established by an outer query — they cannot start or commit that - transaction, since there would be no context for them to execute in. - However, a block containing an EXCEPTION clause effectively + See for information on managing + transactions in PL/pgSQL. + Also, a block containing an EXCEPTION clause effectively forms a subtransaction that can be rolled back without affecting the outer transaction. For more about that see . -- 2.40.0