Re: BUG #17075: Cannot commit when autoCommit is enabled

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17075: Cannot commit when autoCommit is enabled
Дата
Msg-id CAKFQuwY3Zcr2TBQdsJJCSFa+-w3NCP7g0nvaH3snCU67hV9ksw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17075: Cannot commit when autoCommit is enabled  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
On Mon, Jun 28, 2021 at 8:34 AM PG Bug reporting form <noreply@postgresql.org> wrote:
 I need to disable the auto-commit in the DB level for permanently.

PostgreSQL does not provide a knob to enable/disable this.  If you don't use an explicit BEGIN your command will commit as soon as it successfully executes (and will rollback immediately if there is a failure).  As Julien said, though, your driver may be doing stuff above and beyond the SQL commands you yourself send.  Proper usage of you chosen driver/library is outside the scope of the general PostgreSQL mailing lists (and in any case this report does not constitute a bug report).

At least, unless you are using libpq directly or somehow manage to get this to happen in psql.

David J.

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: BUG #17075: Cannot commit when autoCommit is enabled
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17076: Server crashes on composing an error message about invalid modulus for a new table partition