Skip site navigation (1) Skip section navigation (2)

Re: [Fwd: Re: Transactions and SavePoints]

From: Cleber Nardelli <clebernardelli(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Transactions and SavePoints]
Date: 2005-08-31 11:35:03
Message-ID: f90442ed05083104352d0aef0e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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(dot)ristola(at)kolumbus(dot)fi>:
> 
> I sent this off list, so I send this into this list also.
> 
> Marko Ristola
> 
> 
> 
> 
> ---------- Mensagem encaminhada ----------
> From: Marko Ristola <marko(dot)ristola(at)kolumbus(dot)fi>
> To: Cleber Nardelli <clebernardelli(at)gmail(dot)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

In response to

pgsql-odbc by date

Next:From: Carlos Henrique ReimerDate: 2005-08-31 11:57:35
Subject: Re: Transactions and SavePoints
Previous:From: Dave PageDate: 2005-08-31 11:31:47
Subject: Re: Unicode support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group