Hello,
I have read that 7.x version had a model "all or nothing" in transactions.
Thus I have upgraded to version 8 and would like to do the following:
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?
Regards,
Bohdan