Re: No commit nor Rollback button

2017-11-04 Thread Vano Beridze
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 Roa

Re: No commit nor Rollback button

2017-10-19 Thread dangal
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 minimiz

Re: No commit nor Rollback button

2017-10-18 Thread Francis Fish
Regardless of the button or not to button some visual indicator of commit/rollback status that doesn't mean diving into menus would probably help, e.g. a red dot somewhere in a window's decoration meaning that window will auto commit. I come originally from an Oracle background too and remember be

Re: No commit nor Rollback button

2017-10-17 Thread David G. Johnston
On Tue, Oct 17, 2017 at 1:07 AM, Dave Page wrote: > I can see why for some people who choose to turn auto-commit/auto-rollback > off they may be useful, however we cannot simply add new features every > time someone asks for something. Doing so adds maintenance costs, and > increases complexity o

Re: No commit nor Rollback button

2017-10-17 Thread Dave Page
On Tue, Oct 17, 2017 at 6:26 AM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > > On Tue, Oct 17, 2017 at 2:03 AM, legrand legrand < > legrand_legr...@hotmail.com> wrote: > >> Hi Murtuza, >> >> I found those options for switching between autocommit mode and manual >> mode. >> >>

Re: No commit nor Rollback button

2017-10-16 Thread Murtuza Zabuawala
On Tue, Oct 17, 2017 at 2:03 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Hi Murtuza, > > I found those options for switching between autocommit mode and manual > mode. > > What I suggest here is to add one button for commit and one button for > rollback, > they would be green and r

Re: No commit nor Rollback button

2017-10-16 Thread legrand legrand
Hi Murtuza, I found those options for switching between autocommit mode and manual mode. What I suggest here is to add one button for commit and one button for rollback, they would be green and red in manual transaction mode they would be greyed in autocommit mode. A more advanced behavior in

Re: No commit nor Rollback button

2017-10-16 Thread Murtuza Zabuawala
> > > > *From: *"David G. Johnston" > *Date: *Monday, October 16, 2017 at 11:30 AM > *To: *Melvin Davidson > *Cc: *"pgadmin-supp...@postgresql.org" , > legrand legrand > *Subject: *Re: No commit nor Rollback button > > > > On Mon, Oct 16,

Re: No commit nor Rollback button

2017-10-16 Thread Michael Rasmussen
legrand Subject: Re: No commit nor Rollback button On Mon, Oct 16, 2017 at 11:16 AM, Melvin Davidson mailto:melvin6...@yahoo.com>> wrote: You don't need buttons. Just go to File Preferences SQL Editor and change Auto commit? to False and Auto rollback? to False Or wh

Re: No commit nor Rollback button

2017-10-16 Thread David G. Johnston
On Mon, Oct 16, 2017 at 11:16 AM, Melvin Davidson wrote: > *You don't need buttons.* > > *Just go to * > *File* > * Preferences* > *SQL Editor* > > *and change Auto commit? to False* > > * and Auto rollback? to False* > > *Or whatever you prefer.* > > *That is what those options are

Re: No commit nor Rollback button

2017-10-16 Thread Melvin Davidson
You don't need buttons. Just go to File  Preferences    SQL Editor and change Auto commit?   to False        and Auto rollback? to False Or whatever you prefer.That is what those options are for! Or learn how to use a TRANSACTION in PostgreSQL.IE: BEGIN; Melvin Davidson 🎸 I reserve the right to

Re: No commit nor Rollback button

2017-10-16 Thread legrand legrand
Maybe after 20 years, it is time to switch tool default from autocommit to commit/rollback ... to have a chance to be compared with Oracle SQL developer or others PAscal SQLeo projet manager -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: No commit nor Rollback button

2017-10-16 Thread dangal
for me it would be necessary, if possible thanks a lot -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: No commit nor Rollback button

2017-10-16 Thread Dave Page
On Sat, Oct 14, 2017 at 8:14 PM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Hello, > > Most of RDBMS users don't want to use autocommit mode expecting to have a > change to Rollback in case of problem. > > Most of database GUI have Commit/ Rollback buttons (greyed in autocommit > mode

Re: No commit nor Rollback button

2017-10-15 Thread dangal
I think like you, you should have two buttons, commit and rollback -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: No commit nor Rollback button

2017-10-14 Thread Melvin Davidson
Please note, I am not PgAdmin4 support. However, it seems to me that what you want is handled in File  Preferences    SQL Editor     Options    Auto commit?    True/False     Auto rollback?  True/False Melvin Davidson 🎸 I reserve the right to fantasize.  Whether or not you

No commit nor Rollback button

2017-10-14 Thread legrand legrand
Hello, Most of RDBMS users don't want to use autocommit mode expecting to have a change to Rollback in case of problem. Most of database GUI have Commit/ Rollback buttons (greyed in autocommit mode, enabled in non autocommit mode). Is there a chance to see thoses buttons (using preferences or ot