Re: Track pgsql steps

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 available only after the complete 
> end of the procedure.
> 
> Do you see any solution in this purpose ?

RAISE NOTICE?:

https://www.postgresql.org/docs/12/plpgsql-errors-and-messages.html#PLPGSQL-STATEMENTS-RAISE

> 
> Thanks,
> 
> Olivier
> 
> 
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> 
>     Garanti sans virus. www.avast.com 
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> 
> 
> 
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>


-- 
Adrian Klaver
adrian.klaver@aklaver.com