[Fwd: Re: Transactions and SavePoints]

I sent this off list, so I send this into this list also.

Marko Ristola


Unfortunately SAVEPOINTs are not implemented in PsqlODBC yet.

ROLLBACK TO SAVEPOINT -case is easy to fix, but the full
implementation is hard to make correctly for psqlodbc, at least for me.

Marko Ristola

Cleber Nardelli wrote:

>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 the error:
>"ERROR: ROLLBACK TO SAVEPOINT may only be used in transaction blocks"
>
>Necessary of the your help.
>I thank
>
>Yours truly
>
>
>