Re: some question about SavePoint ?

Ludek Finstrle wrote:
>>>There is some common known bugs in 08.01.0102 in implicit rollback.
>>>Do you try latest development snapshot?
>>>Maybe 08.01.0106 could better fit you. I don't know. We have some report
>>>about similar problem (but reporter doesn't mentioned his psqlodbc
>>>version).
>>
>>Do you mean that in 08.01.0106 I must not use the Savepoint to ignore
>>some error ?? When error occurred in 08.01.0106, It can be continued to
>>execute SQL without executing rollback first ???
>
>
> There is some changes with implicit rollback in autocommit = on. I don't
You mean I can use autocommit = on and begin a transaction manually???
Is the implicit rollback to rollback all before ???
> know your situation exactly so it should or shouldn't help you.
> The answer is:
> Maybe yes. You have to try.
>
My situation is like this , can you help me :
1.set autocommit = off ;
2.for(i=0;i<len;i++){
insert into test(c1,c2) values(i,'a');
if dupkey error occur then
update test set c2 = 'b';--error:rollback first???
else {
rollback and return;
}
}
3.commit;

I want to do like this:
1. set autocommit = off ;
2. for(i=0;i<len;i++){
savepoint sp;
insert into test(c1,c2) values(i,'a');
release savepoint sp;
if dupkey error occur then
rollback to sp;
update test set c2 = 'b';
else{
rollback and return;
}
}
3.commit;

Can I use another way to implenment this ? (don't use the savepoint)
thanks.

Regards,
zhao

>
>>What I want is to ignore some error returned ,and coninue to execute my
>>SQL , do I have another way ?
>
>
> Yes, you have. You could send us your mylog output and we could take
> a look at your problem. But you could be sure we don't study 08.01.0102
> mylog output becouse there are changes in development snapshots.
>
> The best way is try tha latest development snapshot (08.01.0107). We're
> going to release new "stable" version based ont 08.01.0107 in relative
> short time. So if you want have easier life with new stable release you
> may try the 08.01.0107 and report problem if there is one.
>
> Regards,
>
> Luf
>

--

以上、よろしくお願いいたします。

---------------------------------------------------------
Zhao Xin
NEC-CAS Software Laboratories Co.,Ltd.
Tel : 8233-4433-425
Telnet : 8-0086-22-425
E-mail:　zhaox(at)necas(dot)nec(dot)com(dot)cn
--------------------------------------------------------