From: | mpomykacz <m(dot)pomykacz(at)alfavox(dot)pl> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Auto rollback option |
Date: | 2017-02-14 13:44:30 |
Message-ID: | 1487079870172-5944163.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2017-02-14 16:51:37 | Re: Auto rollback option |
Previous Message | Dave Page | 2017-02-14 10:40:05 | Re: pgAdmin4 and Archlinux |