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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
