I personally prefer it the way it is. I am not migrating from Oracle,
which could be the reason. If I want a transaction, I specify it. If I
don't want a transaction I don't specify it.
I think a lot more people would have issues if they run a couple dozen
queries and then turn it off and forget t
I'll give you an example.
I am debugging a certain function named do_lots_stuff();
So I write the code like that:
rollback;
begin;
select do_lots_stuff();
And I can freely run it a few times. However usually this is not that
simple. In debugging a certain function/triggers I have to run many
di