Michael Segel wrote: <snip> > Having said that, Daniel already made a suggestion which is in use today by > other databases.... > > The simplest solution would be to find the MAX value, rest the sequence to > MAX() +1 and re-insert the row. > > There are other possible solutions. > > It's disappointing that certain people don't accept this as a bug
Craig Russell wrote earlier in this thread [1]: > Do you have a good solution that you can write up in detail and post to > JIRA? Then someone with an itch can fix it. Do-ocracy in action. Anyone is welcome to open a Jira issue. Jira assistance is at http://db.apache.org/derby/DerbyBugGuidelines.html . -jean [1] http://mail-archives.apache.org/mod_mbox/db-derby-user/200605.mbox/[EMAIL PROTECTED]
