Re: Procedures

On Tue, Aug 25, 2020 at 03:03:13PM -0400, Bruce Momjian wrote: > On Tue, Aug 25, 2020 at 08:38:11PM +0200, Peter Eisentraut wrote: > > On 2020-08-24 18:00, Bruce Momjian wrote: > > > -command, a procedure is called explicitly using > > > -the statement. > > > +command, a procedure is c

Re: Procedures

On Tue, Aug 25, 2020 at 08:38:11PM +0200, Peter Eisentraut wrote: > On 2020-08-24 18:00, Bruce Momjian wrote: > > -command, a procedure is called explicitly using > > -the statement. > > +command, a procedure is called in isolation using > > +the command. If the CALL command is n

Re: Procedures

On 2020-08-24 18:00, Bruce Momjian wrote: -command, a procedure is called explicitly using -the statement. +command, a procedure is called in isolation using +the command. If the CALL command is not +part of an explicit transaction, a procedure can commit, rollback, +an

Re: Procedures

On Mon, Aug 24, 2020 at 9:09 AM Pavel Stehule wrote: > > > po 24. 8. 2020 v 18:00 odesílatel Bruce Momjian napsal: > >> On Mon, Aug 24, 2020 at 05:51:29PM +0200, Pavel Stehule wrote: >> > sure. Maybe enhancing about sentence like "it is not possible in a >> function." >> > >> > and >> > >> > "a

Re: Procedures

po 24. 8. 2020 v 18:00 odesílatel Bruce Momjian napsal: > On Mon, Aug 24, 2020 at 05:51:29PM +0200, Pavel Stehule wrote: > > sure. Maybe enhancing about sentence like "it is not possible in a > function." > > > > and > > > > "a procedure can commit (or rollback) and begin new transactions during

Re: Procedures

On Mon, Aug 24, 2020 at 05:51:29PM +0200, Pavel Stehule wrote: > sure. Maybe enhancing about sentence like "it is not possible in a function." > > and > > "a procedure can commit (or rollback) and begin new transactions during its >         execution" OK, updated patch. -- Bruce Momjian

Re: Procedures

po 24. 8. 2020 v 17:38 odesílatel Bruce Momjian napsal: > On Mon, Aug 24, 2020 at 11:35:57AM -0400, Bruce Momjian wrote: > > On Mon, Aug 24, 2020 at 05:24:19PM +0200, Pavel Stehule wrote: > > > > > > > > > po 24. 8. 2020 v 17:01 odesílatel Bruce Momjian > napsal: > > > > > > On Sat, Aug 22,

Re: Procedures

On Mon, Aug 24, 2020 at 11:35:57AM -0400, Bruce Momjian wrote: > On Mon, Aug 24, 2020 at 05:24:19PM +0200, Pavel Stehule wrote: > > > > > > po 24. 8. 2020 v 17:01 odesílatel Bruce Momjian napsal: > > > > On Sat, Aug 22, 2020 at 01:21:43PM -0700, David G. Johnston wrote: > > > On Sat, Au

Re: Procedures

On Mon, Aug 24, 2020 at 05:24:19PM +0200, Pavel Stehule wrote: > > > po 24. 8. 2020 v 17:01 odesílatel Bruce Momjian napsal: > > On Sat, Aug 22, 2020 at 01:21:43PM -0700, David G. Johnston wrote: > > On Sat, Aug 22, 2020 at 10:14 AM Bruce Momjian wrote: > > > >     On Fri, Aug

Re: Procedures

po 24. 8. 2020 v 17:01 odesílatel Bruce Momjian napsal: > On Sat, Aug 22, 2020 at 01:21:43PM -0700, David G. Johnston wrote: > > On Sat, Aug 22, 2020 at 10:14 AM Bruce Momjian wrote: > > > > On Fri, Aug 21, 2020 at 07:42:35PM -0700, David G. Johnston wrote: > > > > > [...] the CALL comma

Re: Procedures

On Sat, Aug 22, 2020 at 01:21:43PM -0700, David G. Johnston wrote: > On Sat, Aug 22, 2020 at 10:14 AM Bruce Momjian wrote: > > On Fri, Aug 21, 2020 at 07:42:35PM -0700, David G. Johnston wrote: > > > [...] the CALL command.  If the CALL command is not part of an explicit > > transact

Re: Procedures

On Sat, Aug 22, 2020 at 10:14 AM Bruce Momjian wrote: > On Fri, Aug 21, 2020 at 07:42:35PM -0700, David G. Johnston wrote: > > > [...] the CALL command. If the CALL command is not part of an explicit > > transaction a procedure can also manage multiple transactions during its > > execution. > >

Re: Procedures

On Fri, Aug 21, 2020 at 07:42:35PM -0700, David G. Johnston wrote: > On Fri, Aug 21, 2020 at 3:52 PM Bruce Momjian wrote: > > > > Agreed, this doc area needs help. > > I developed the attached patach for this.  Is this sufficient? > > > For consistency I would change "statement" to "c

Re: Procedures

On Sat, Aug 22, 2020 at 12:05:24PM +0100, Robin Abbi wrote: > On Fri, 21 Aug 2020 at 23:52, Bruce Momjian 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

Re: Procedures

On Saturday, August 22, 2020, Jürgen Purtz wrote: > On 22.08.20 13:05, Robin Abbi wrote: > > On Fri, 21 Aug 2020 at 23:52, Bruce Momjian wrote: > >> I developed the attached patach for this. Is this sufficient? >> > > Would it be appropriate to consider including some language with a similar >

Re: Procedures

On 22.08.20 13:05, Robin Abbi wrote: On Fri, 21 Aug 2020 at 23:52, Bruce Momjian > 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 "

Re: Procedures

On Fri, 21 Aug 2020 at 23:52, Bruce Momjian 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 thei

Re: Procedures

On Fri, Aug 21, 2020 at 3:52 PM Bruce Momjian wrote: > > > Agreed, this doc area needs help. > > I developed the attached patach for this. Is this sufficient? > For consistency I would change "statement" to "command" at the end of that paragraph . the command. and to contrast with "a p

Re: Procedures

On Thu, Aug 6, 2020 at 06:10:52PM -0400, Bruce Momjian wrote: > On Thu, Aug 6, 2020 at 02:30:55PM +0100, Robin Abbi wrote: > > PostgreSQL went as far as release 10 without procedures. > > Some third party resources written before 11 loosely conflate procedures > > with > > functions. > > Some th

Re: Procedures

On Thu, Aug 6, 2020 at 02:30:55PM +0100, Robin Abbi wrote: > PostgreSQL went as far as release 10 without procedures. > Some third party resources written before 11 loosely conflate procedures with > functions. > Some third party resources written before 11 accurately state PostgreSQL has > functi

Re: Procedures

PostgreSQL went as far as release 10 without procedures. Some third party resources written before 11 loosely conflate procedures with functions. Some third party resources written before 11 accurately state PostgreSQL has functions but not procedures. Referring to the PostgreSQL docs for 11 on, pr

Re: Procedures

On Wed, 5 Aug 2020 at 20:18, Bruce Momjian wrote: > On Tue, Aug 4, 2020 at 10:33:49AM +, 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

Re: Procedures

On Tue, Aug 4, 2020 at 10:33:49AM +, 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 featu