Privet vsem!

U menya problema s subj. I delayu udalenie PK, udalenie vseh zapisey tablitcy, sozdayu PK. Poluchayu subj. Transakcya commited posle kajdoy operaciy.

Eto bug ili ya deleyu nepravilino?

Mike

Rabotayu cherez IBX.

Ispolzuetsya 2 TIBTransaction. Otmecheny v pseudocode kak transaction1 and transaction2

1. alter table ... drop constraint ... (udalyaem PK)
2. commit(transaction1)
... also removed rest of indecies on that table using same transaction, each operation is commited separately

3. delete from table
4. commit(transaction1)
5. select count(*) from table
6. commit(transaction1) //forsing IB garbage collection


7. for i := 0 to 10000 insert into ... values (...)
if mod(i, 1000) = 0 then commit(transaction2)

8. if transaction2.inTransaction commit(transaction2)

9. alter table ... add constrain primary key
10. commit(transaction1)
Here I got that error message

Vot chto interesno, inogda eto rabotaet, inogda net.

Mike