BUG #2265: CREATE TABLE when AUTOCOMMIT is OFF
| От | Gerhard Lutz |
|---|---|
| Тема | BUG #2265: CREATE TABLE when AUTOCOMMIT is OFF |
| Дата | |
| Msg-id | 20060216132118.3D3C0F0B05@svr2.postgresql.org обсуждение |
| Ответы |
Re: BUG #2265: CREATE TABLE when AUTOCOMMIT is OFF
|
| Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2265 Logged by: Gerhard Lutz Email address: gerhard.lutz@mbtech-group.com PostgreSQL version: 8.1.3 Operating system: Windows XP SP2 Description: CREATE TABLE when AUTOCOMMIT is OFF Details: I want to upgrade my PostgreSQL server from 8.0.4 to 8.1.3. My application connects to the database via ODBC. After connecting to the database I set the AUTOCOMMIT mode to OFF. ::SQLSetConnectAttr(g_hDBConnection, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMMIT_OFF), 0); Now, if I want do create a table via ODBC, e.g. "CREATE TABLE db_version ( hv integer, uv integer, nv integer, r integer, rel integer)" , I get the error message "Error while executing the query; ERROR: current transaction is aborted, commands ignored until end of transaction block (7)" In PostgreSQL 8.0.4 I was able to create a table in AUTOCOMMIT mode OFF without any error. Is this a bug in 8.1.3?
В списке pgsql-bugs по дате отправления: