Thread: BUG #1857: Problem with driver ODBC
The following bug has been logged online: Bug reference: 1857 Logged by: Cleber Nardelli Email address: nardelli@ipm.com.br PostgreSQL version: 8.0.3 Operating system: Windows XP Professional (Client) RedHat 9 Linux (Server) Description: Problem with driver ODBC Details: Hello. I am using the Driver odbc for access to postgresql. I have a referring problem to the cancellation of the transaction when some error is found at the moment of the execution of the same one. I try to execute this sql command: BEGIN TRANSACTION; DELETE FROM TABL1 WHERE ID = 1; INSERT INTO TABL1 VALUES (1,1); SAVEPOINT SVPT; INSERT INTO TABL1 VALUES (1,1); ROLLBACK TO SAVEPOINT SPVT; COMMIT; When I try to insert as register it accuses to error with key duplicate. Ok. But I do not want to cancel the transaction I I need to only continue with the same one skirting this error. For this reason i am using SavePoints but it generates a error: "ERROS: ROLLBACK TO SAVEPOINT may only be used in transaction blocks" version of driver 7.03.00 or 8.x. Necessary of the your help. I thank Yours truly -- Cleber Nardelli
On Tue, Aug 30, 2005 at 08:53:24PM +0100, Cleber Nardelli wrote: > BEGIN TRANSACTION; > DELETE FROM TABL1 WHERE ID = 1; > INSERT INTO TABL1 VALUES (1,1); > SAVEPOINT SVPT; > INSERT INTO TABL1 VALUES (1,1); > ROLLBACK TO SAVEPOINT SPVT; > COMMIT; > > When I try to insert as register it accuses to error with key duplicate. > Ok. > But I do not want to cancel the transaction I I need to only continue with > the same one skirting this error. For this reason i am using SavePoints but > it generates a error: > "ERROS: ROLLBACK TO SAVEPOINT may only be used in transaction blocks" Forgiving my ignorance on ODBC matters, may I ask: do you have autocommit set to on? Did you try changing that? -- Alvaro Herrera <alvherre[]alvh.no-ip.org> Architect, www.EnterpriseDB.com Officer Krupke, what are we to do? Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")