Review request for Postgres Enterprise Manager, Akshay Joshi and Ashesh Vashi.
By Sanket Mehta.
Repository: PEM
Description
In Autocommit on/off option in pem client:
"Enable autocommit" option is provided in pem client at 2 places:
1. pem client -> File menu -> Options -> Query Editor -> Enable AUTO COMMIT
2. sql query tool -> Query menu -> Auto-commit
User can select/deselect its value from any of the above 2 places and it will be reflected to other one.
In any query tool session, once user uncheck this checkbox, depending upon postgreSQL standard for executing the query it will execute "BEGIN;" statement first at the time of executing the query and thus setting the autocommit off for that session.
User can set the autocommit on at any time by selecting the checkbox from above mentioned places.
But it will be active only after user has completed the transaction block(started by BEGIN as mentioned above) by END or ROLLBACk or COMMIT;
Testing
- setting autocommit on/off from client window.
- setting autocommit on/off from query tool.
- Setting the autocommit mode on/off in database