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
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
>
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.
>>
>>
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
ineer
>
> Porch
>
>
>
> *From: *"David G. Johnston" <david.g.johns...@gmail.com>
> *Date: *Monday, October 16, 2017 at 11:30 AM
> *To: *Melvin Davidson <melvin6...@yahoo.com>
> *Cc: *"pgadmin-supp...@postgresql.org" <pgadmin-supp...@pos
>
Cc: "pgadmin-supp...@postgresql.org" <pgadmin-supp...@postgresql.org>, legrand
legrand <legrand_legr...@hotmail.com>
Subject: Re: No commit nor Rollback button
On Mon, Oct 16, 2017 at 11:16 AM, Melvin Davidson
<melvin6...@yahoo.com<mailto:melvin6...@yahoo.com
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
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
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
>
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
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
11 matches
Mail list logo