Re: No commit nor Rollback button

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: No commit nor Rollback button
Дата
Msg-id CAKFQuwa+=WPjCHjfM2OswEDZpCeudyWvHHgE_P6Pt+a8xXVYKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: No commit nor Rollback button  (Melvin Davidson <melvin6925@yahoo.com>)
Ответы Re: No commit nor Rollback button  (Michael Rasmussen <michaelr@porch.com>)
Список pgadmin-support
On Mon, Oct 16, 2017 at 11:16 AM, Melvin Davidson <melvin6925@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 whatever you prefer.
That is what those options are for!

Or learn how to use a TRANSACTION in PostgreSQL.
IE:
BEGIN;


​Personally, if I'm in a GUI I'd prefer buttons.  They both allow one to quickly see whether they are in a transaction or not (by greying out the buttons when their use is not applicable) and provide a mouse user a very quick way to commit/rollback the query they just executed via clicking the "run query" button.

This has absolutely nothing to do with "Auto Commit/Rollback" other than the buttons would only be meaningful when said option is disabled.

​David J.

В списке pgadmin-support по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: No commit nor Rollback button
Следующее
От: legrand legrand
Дата:
Сообщение: Re: Data grid: fetching/scrolling data on user demand