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 по дате отправления: