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

Re: Transactions and SavePoints

From: Carlos Henrique Reimer <carlosreimer(at)yahoo(dot)com(dot)br>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Transactions and SavePoints
Date: 2005-08-31 11:57:35
Message-ID: 20050831115735.91661.qmail@web53206.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Is there a ODBC flavor than can implement ROLLBACK TO SAVEPOINT?
 
Marko Ristola wrote:
> 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
>>

		
---------------------------------
Yahoo! Acesso Grátis: Internet rápida e grátis. Instale o discador agora!

Responses

pgsql-odbc by date

Next:From: Scot LoachDate: 2005-08-31 12:52:00
Subject: Re: changed behavior in libpq odbc driver
Previous:From: Cleber NardelliDate: 2005-08-31 11:35:03
Subject: Re: [Fwd: Re: Transactions and SavePoints]

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