Re: [Fwd: Re: Transactions and SavePoints]

OK.
Then I have two questions:
1 -  They exist plain of implantation of the SAVEPOINTS in psqlODBC?
2 -  If not to exist or is for long stated period, would exist an
alternative for this problem through other driver ODBC that you can
indicate me?

Yours truly

Cleber Nardelli

2005/8/31, Marko Ristola <marko.ristola@kolumbus.fi>:
>
> I sent this off list, so I send this into this list also.
>
> Marko Ristola
>
>
>
>
> ---------- Mensagem encaminhada ----------
> From: Marko Ristola <marko.ristola@kolumbus.fi>
> To: Cleber Nardelli <clebernardelli@gmail.com>
> Date: Wed, 31 Aug 2005 06:37:39 +0300
> Subject: Re: [ODBC] Transactions and SavePoints
>
> 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
> >
> >
> >
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
>


--
Cleber Nardelli
IPM Automação e Consultoria
9998-8670