I also come from Oracle and all tools have autocommit disabled by default.
It's more natural to make sure that everything went well and only after that commit the transaction.
Sometimes you realize that you made a huge mistake. Rollback is your friend. Vano Beridze Software Developer Silk Road Group On 10/20/2017 2:58 AM, dangal wrote:
Actually to manage a production environment I do not understand how someone can use the auto commit. In most Oracle database management tools, they all have the commit and rollback buttons. I do not think it's so complicated to add and it complicates your maintenance a lot I do not want to minimize the work of the developer and maintains -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html
