Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3Tbh-0001J2-Kc for pgsql-docs@arkaria.postgresql.org; Thu, 06 Aug 2020 00:18:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k3Tbg-0007Fy-E9 for pgsql-docs@arkaria.postgresql.org; Thu, 06 Aug 2020 00:18:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3Tbg-0007Fr-2m for pgsql-docs@lists.postgresql.org; Thu, 06 Aug 2020 00:18:04 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3Tbb-0007Bp-Bu for pgsql-docs@lists.postgresql.org; Thu, 06 Aug 2020 00:18:02 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1k3Tba-0007M5-4i; Wed, 05 Aug 2020 20:17:58 -0400 Date: Wed, 5 Aug 2020 20:17:58 -0400 From: Bruce Momjian To: robin.abbi@downley.net, pgsql-docs@lists.postgresql.org Subject: Re: Procedures Message-ID: <20200806001758.GA29874@momjian.us> References: <159653722937.654.5519018237996991238@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <159653722937.654.5519018237996991238@wrigleys.postgresql.org> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee