On Thu, Sep 08, 2005 at 01:23:56PM +0200, Bohdan Linda wrote: > plpgsq code does time intensive data manipulation + database vacuuming. > This data manipulation is splitted logically into several steps. After > each step I would like to give a message to the status table, what the > procedure is performing. > > Currently I pass the information to the table via insert, but this is also > the limitation. I would like to allow another user see the progress of the > current pgplsql procedure, but no insert is commited, till procedure ends. > > How this can be solved? One way would be to use contrib/dblink to open another connection to the database so the status messages could be inserted in a separate transaction. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
