Re: Track pgsql steps

2020-08-05 Thread Pavel Stehule
Hi st 29. 7. 2020 v 19:55 odesílatel Olivier Leprêtre napsal: > Hi, > > > > I have a rather long pgsql procedure and I would like to detect which step > is currently executing (subscript 1,2,3…). Due to transaction isolation, > it’s not possible to make it write in a table or get nexval from a s

Re: Track pgsql steps

2020-07-30 Thread Diego
et 2020 12:19 À : Adrian Klaver Cc : Olivier Leprêtre ; pgsql-general Objet : Re: Track pgsql steps On Wed, Jul 29, 2020 at 7:58 PM Adrian Klaver wrote: On 7/29/20 8:44 AM, Olivier Leprêtre wrote: Hi, I have a rather long pgsql procedure and I would like to detect which step is currently execu

RE: Track pgsql steps

2020-07-30 Thread Olivier Leprêtre
. Olivier -Message d'origine- De : Julien Rouhaud Envoyé : jeudi 30 juillet 2020 12:19 À : Adrian Klaver Cc : Olivier Leprêtre ; pgsql-general Objet : Re: Track pgsql steps On Wed, Jul 29, 2020 at 7:58 PM Adrian Klaver wrote: > > On 7/29/20 8:44 AM, Olivier Leprêtre wrote: >

Re: Track pgsql steps

2020-07-30 Thread Julien Rouhaud
On Wed, Jul 29, 2020 at 7:58 PM Adrian Klaver wrote: > > On 7/29/20 8:44 AM, Olivier Leprêtre wrote: > > Hi, > > > > I have a rather long pgsql procedure and I would like to detect which > > step is currently executing (subscript 1,2,3…). Due to transaction > > isolation, it’s not possible to make

Re: Track pgsql steps

2020-07-29 Thread Adrian Klaver
On 7/29/20 8:44 AM, Olivier Leprêtre wrote: Hi, I have a rather long pgsql procedure and I would like to detect which step is currently executing (subscript 1,2,3…). Due to transaction isolation, it’s not possible to make it write in a table or get nexval from a sequence because values become

Track pgsql steps

2020-07-29 Thread Olivier Leprêtre
Hi, I have a rather long pgsql procedure and I would like to detect which step is currently executing (subscript 1,2,3…). Due to transaction isolation, it’s not possible to make it write in a table or get nexval from a sequence because values become available only after the complete end of the p