From: Bruce Momjian <bruce@momjian.us>
To: robin.abbi@downley.net
To: pgsql-docs@lists.postgresql.org
Subject: Re: Procedures
Date: Wed, 5 Aug 2020 20:17:58 -0400
Message-ID: <20200806001758.GA29874@momjian.us> (raw)
In-Reply-To: <159653722937.654.5519018237996991238@wrigleys.postgresql.org>
References: <159653722937.654.5519018237996991238@wrigleys.postgresql.org>
On Tue, Aug 4, 2020 at 10:33:49AM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/11/sql-createprocedure.html
> Description:
>
> The information on procedures could helpfully include that the feature is
> new from PostgreSQL 11 and give an explanation of how it differs from
> functions. I found the information I needed here
> https://dba.stackexchange.com/a/262662, but I think it would really benefit
> others if the information was provided in the official documentation.
We don't normally mention what release added a features. However, I do
see your problem with finding that procedures can issue transaction
control statements. I see this for procedures:
https://www.postgresql.org/docs/12/xproc.html
but that has no mention of transactions, just a mention of using CALL,
then this pl/pgSQL section about transaction control mentions CALL:
https://www.postgresql.org/docs/12/plpgsql-transactions.html
Is this what you think needs improving?
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, robin.abbi@downley.net, pgsql-docs@lists.postgresql.org
Subject: Re: Procedures
In-Reply-To: <20200806001758.GA29874@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox