Transactionless ODBC
От | Alex Stewart |
---|---|
Тема | Transactionless ODBC |
Дата | |
Msg-id | 200006051844.OAA07812@quill.freedomintelligence.com обсуждение исходный текст |
Ответы |
Re: Transactionless ODBC
|
Список | pgsql-interfaces |
Hello, Is there a way to execute a SQL query without using a transaction under ODBC? I'm trying to create a user and I get the following output: OpenLink ODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DSN=Testing SQL>create user roger Error creating the table; ERROR: CREATE USER: may not be called in a transaction block, SQLSTATE=S0001 ERROR: CREATE USER: may not be called in a transaction block, SQLSTATE=S1000 My ~/.odbc.ini is: [ODBC Data Sources] Testing = Debugging Database [Testing] Driver = /usr/local/lib/libpsqlodbc.so Debug = 1 CommLog = 1 ReadOnly = 0 Servername = localhost Username = freedom Password = "joint" Port = 5432 Database = testcdbc [ODBC] InstallDir = /var/lib/pgsql Problem code seems to be in interfaces/odbc/statement.c:748. There's an if statement that I think I want to be false, but I don't know how. I don't want to have to call an shell script to create my users, but that seems like the way to go, now. Alex Stewart
В списке pgsql-interfaces по дате отправления: