I would say you should not do that in almost any database. Do not never keep transactions open for much longer than necessary.