Re: Surprising behaviour of \set AUTOCOMMIT ON

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: Surprising behaviour of \set AUTOCOMMIT ON
Дата
Msg-id 36ccfa8d-0f00-6acf-e7b4-6a14bc0bb281@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Surprising behaviour of \set AUTOCOMMIT ON  (Rahila Syed <rahilasyed90@gmail.com>)
Список pgsql-hackers
Hi,

Some minor comments.

+        <note>
+        <para>
+         Autocommit cannot be set on inside a transaction, the ongoing
+         transaction has to be ended by entering <command>COMMIT</> or
+         <command>ROLLBACK</> before setting autocommit on.
+        </para>
+        </note>

I guess: "cannot be set *to* on" and likewise for "setting autocommit on"

The error message further in the patch spells it correctly:

+    psql_error("\\%s: Cannot set %s to %s inside a transaction, ...

Also (maybe): s/Autocommit/AUTOCOMMIT/g

Thanks,
Amit





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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Logical decoding slots can go backwards when used from SQL, docs are wrong
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling)