A bad behavior under autocommit off mode
| От | Hiroshi Inoue |
|---|---|
| Тема | A bad behavior under autocommit off mode |
| Дата | |
| Msg-id | 3E54526A.121EBEE5@tpf.co.jp обсуждение исходный текст |
| Ответы |
Re: A bad behavior under autocommit off mode
Re: A bad behavior under autocommit off mode |
| Список | pgsql-hackers |
Hi all, There seems a bad behavior under autocommit off mode. 1) psql -c 'set autocommit to off;select 1;commit' causes a WARNING: COMMIT: no transaction in progress whereas 2) psql -c 'begin;select 1;commit' causes no error/warning. Note that the result is the same even when you issue the first set/begin command separately using the client softwares other than psql. The problem here is that the transaction is cancelled in case of 1) though no error is reported. Shouldn't we avoid the warning and the cancellation ? Or should an error be reported instead of the warning ? regards, Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/
В списке pgsql-hackers по дате отправления: