Auto rollback option

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.

Responses

Browse pgadmin-support by date

  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