On Saturday, August 22, 2020, Jürgen Purtz <
juergen@purtz.de> wrote:
On 22.08.20 13:05, Robin Abbi wrote:
On Fri, 21 Aug 2020 at 23:52, Bruce Momjian <
bruce@momjian.us> wrote:
I developed the attached patach for this. Is this sufficient?
Would it be appropriate to consider including some language with a similar information content to this
" ... prior to PostgreSQL 11, these functions were unable to manage their own transactions. PostgreSQL 11 adds SQL procedures that can perform full transaction management within the body of a function, enabling developers to create more advanced server-side applications, such as ones involving incremental bulk data loading."
Robin Abbi
Can we more clearly distinguish between "function" and "procedure"? eg:
"Developers have been able to create user-defined functions in PostgreSQL since decades, but functions are unable to manage their own transactions. PostgreSQL 11 adds SQL procedures that can perform full transaction management within their body, enabling developers to create more advanced server-side applications, such as ones involving incremental bulk data loading."
as a modification of the original release notes:
"Developers have been able to create user-defined functions in PostgreSQL for over 20 years, but prior to PostgreSQL 11, these functions were unable to manage their own transactions. PostgreSQL 11 adds SQL procedures that can perform full transaction management within the body of a function, enabling developers to create more advanced server-side applications, such as ones involving incremental bulk data loading."
Neither the 20 years or mention of specific versions are included in the main body of the documentation. If a feature exists its documented in that version in such a manner as “this is how things are”.
Replacing “their body” with “the body of a function” isn’t an improvement.
David J.