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