Re: [pgadmin-support] Fwd: [NOVICE] Autocommit in Postgresql

2005-05-14 Thread Sim Zacks
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

Re: [pgadmin-support] Fwd: [NOVICE] Autocommit in Postgresql

2005-05-14 Thread Vitaly Belman
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