[pgadmin-support] Auto rollback option - Mailing list pgadmin-support

From mpomykacz
Subject [pgadmin-support] Auto rollback option
Date
Msg-id 1487079870172-5944163.post@n3.nabble.com
Whole thread Raw
Responses Re: [pgadmin-support] Auto rollback option  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support
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.



pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: [pgadmin-support] pgAdmin4 and Archlinux
Next
From: Dave Page
Date:
Subject: Re: [pgadmin-support] Auto rollback option