From: | Sanket Mehta <sanket(dot)mehta(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | autocommit feature in pgadmin |
Date: | 2015-03-24 12:31:23 |
Message-ID: | CA+yw=mOO0vb4S46hKVujZSCDCXwMDp8241Bh0wf7FrMWDjP-zQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi,
Below is the description of the autocommit feature implementation in
pgadmin:
This feature is only applicable in query editor.
Autocommit can be set on/off from 2 places.
1. pgadmin main browser -> File menu -> Options -> Query tool -> Query
editor -> Enable Auto commit
2. In Query editor -> Query menu -> Auto-commmit
By default auto commit will be enabled in pgadmin.
In any query editor session, once user uncheck this autocommit checkbox,
depending upon postgreSQL standard for executing the query it will execute
"BEGIN;" statement before executing the actual 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;
Let me know in case of any queries.
Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb
From | Date | Subject | |
---|---|---|---|
Next Message | Prasad | 2015-03-25 10:35:37 | Re: Patch : PGPASSFILE fix |
Previous Message | Sanket Mehta | 2015-03-24 11:57:53 | Re: Review Request 306: RM 33614 - Autocommit on/off option in PEM client |