Received: from wall.webpearls.com (IDENT:qmailr@wall.webpearls.com [204.138.113.157]) by hub.org (8.10.1/8.10.1) with SMTP id e55IfBW47639 for ; Mon, 5 Jun 2000 14:41:11 -0400 (EDT) Received: (qmail 22144 invoked from network); 5 Jun 2000 18:51:22 -0000 Received: from qatest.freedomintelligence.com (HELO quill.freedomintelligence.com) (root@10.0.0.15) by masq.freedomintelligence.com with SMTP; 5 Jun 2000 18:51:22 -0000 Received: (from alex@localhost) by quill.freedomintelligence.com (8.9.3/8.9.3) id OAA07812 for pgsql-interfaces@postgresql.org; Mon, 5 Jun 2000 14:44:46 -0400 From: Alex Stewart Message-Id: <200006051844.OAA07812@quill.freedomintelligence.com> Subject: Transactionless ODBC To: pgsql-interfaces@postgresql.org Date: Mon, 5 Jun 2000 14:44:46 -0400 (EDT) X-Mailer: ELM [version 2.5 PL3] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/31 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