Commit query notice or button to commit query when auto-commit checkbox disabled

[daevidvincent]

Is your feature request related to a problem? Please describe.
I just wasted literally hours performing some updates on 6 x SDLC environments to UPDATE three tables with millions of rows that takes 45 minutes each to complete! This is because if "auto-commit" is OFF, the query LOOKS like it does something, but actually didn't do anything!

I don't see the purpose of this checkbox when you already have a read-only connection to prevent writing.

Describe the solution you'd like
If AUTO-COMMIT is UNCHECKED,

1. put some kind of indicator in the bottom status bar that this is a "read only" connection or however you want to word it.
2. after a query that requires COMMIT make it obvious with a big red banner or something in the result set output, or at the bottom this has NOT been commited.
3. in the result set where it misleadingly says, "Updated Rows: 814899" it should change to "Potentially Updated Rows: 814899 -- COMMIT changes pending" or something like that
4. give me a button to push to actually perform the COMMIT or a yes/no dialog box or something! Maybe make the "COMMIT changes pending" in PostgreSQL: SSL support #3 a link that does the action?

Describe alternatives you've considered
I've considered punching a baby in the face because I have had to stay up late to run these queries after multi-timezones have gone to sleep and so to be less disruptive...

Additional context
Think of the children! Think how many hours of frustration you would save pleebs like me who apparently are too stupid to know that they have to remember that this checkbox is off and now have to COMMIT their changes, yet I don't even know how or where to do that when running a query such as this...

[uslss]

thanks for suggestion

[GeriZ]

Hi,

you can see the commit status of your connection in SQL editor. When the commit and rollback buttons are greyed out then autocommit is active. When they are not greyed out then autocommit is off.

Regards
Geri