Thread: BUG #1857: Problem with driver ODBC

BUG #1857: Problem with driver ODBC

From
"Cleber Nardelli"
Date:
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

Re: BUG #1857: Problem with driver ODBC

From
Alvaro Herrera
Date:
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")