Postgres Pro
Downloads
Home   >   mailing lists

Track pgsql steps - Mailing list pgsql-general

From Olivier Leprêtre
Subject Track pgsql steps
Date
Msg-id 080c01d665bf$370bfde0$a523f9a0$@gmail.com
Whole thread Raw
Responses Re: Track pgsql steps  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Track pgsql steps  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view

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

 

 


Garanti sans virus. www.avast.com

pgsql-general by date:

Previous
From: Ben Madin
Date:
Subject: Re: How to create function returning numeric from string containing percent character
Next
From: Adrian Klaver
Date:
Subject: Re: Track pgsql steps