It might work if you undef the objects explicitly, but at that point the DWIM magic is gone.

In general, I think it's better to be explicit about hairy things like transactions. I would make the part of the program that calls the data objects handle creating and committing the transaction.