Is it possible to [periodically] commit within a user-defined procedure? If so, how do I do that?
In this case, I don't need to worry about the procedure being atomic and isolated in the ACID sense so I can commit regularly in order to release locks...