db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vandahl ...@apache.org>
Subject Re: Torque/Oracle 10 Incrementation problem
Date Sun, 21 May 2006 10:29:39 GMT
Wizard of OS wrote:
> first of all, please do *not* send HTML encoded mail to mailinglists nor 
> to others at all, they are a plague.
My mail reader shows Thomas' message as text/plain.

> I already realized what you have described.
> I made direct SQL commit and oracle incremented the sequence anyway.
> A transaction w/ rollback didn't work also. I think that the sequence 
> concept in Oracle is diffent to regular autoincrement.
MySQL does the same. If you add a record to a table with autoincrement 
on and rollback, the autoincrement value will not be decremented, which 
leaves a "hole" in your primary key sequence.

Bye, Thomas.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message