Track pgsql steps

From: Olivier Leprêtre <o(dot)lepretre(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Track pgsql steps
Date: 2020-07-29 15:44:58
Message-ID: 080c01d665bf$370bfde0$a523f9a0$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
procedure.

Do you see any solution in this purpose ?

Thanks,

Olivier

--
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-07-29 17:58:09 Re: Track pgsql steps
Previous Message Ben Madin 2020-07-29 15:16:34 Re: How to create function returning numeric from string containing percent character