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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
