Thread: [pgadmin-support] Auto rollback option
Hey, I just installed the newest pgAdmin4 1.2 version. My question is - could Auto-Rollback option be set to True on default (like Auto-Commit)? Could you do it in the next version? I know I can set the Auto-Rollback to True in Preferences --> SQL Editor --> Options. But the problem is that in our company me and my team are just preparing packages (set of instructions to DB between BEGIN TRANSACTION; and COMMIT TRANSACTION) but they are executing by other team. I cannot be sure that this 'other team' will remember about the 'click' in preferences on all of our customers' computers. Auto-Rollback is necessary for us when we have a lot of packages to execute one after the other. For now, if some instruction causes an error the transaction will stay open (for the next package). But with the Auto-Rollback ON - the transaction will be closed. And this is what i want - to close the transaction if some instruction causes an error without setting Auto-Rollback to True manually :) -- View this message in context: http://postgresql.nabble.com/Auto-rollback-option-tp5944163.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Tue, Feb 14, 2017 at 1:44 PM, mpomykacz <m.pomykacz@alfavox.pl> wrote: > Hey, > I just installed the newest pgAdmin4 1.2 version. > My question is - could Auto-Rollback option be set to True on default (like > Auto-Commit)? > Could you do it in the next version? Not really - that would change a setting that's been the default for 15 years in pgAdmin 3 & 4 (probably longer, as it was also the default in pgAdmin 1 & 2), in response to a single request. It would help you, but probably confuse a lot of other users. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company