Re: BUG #1857: Problem with driver ODBC

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")