Re: Partial commit within the trasaction

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