<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - After renaming Primary Key AutoValue feature fails" href="https://bugs.documentfoundation.org/show_bug.cgi?id=108058#c1">Comment # 1</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - After renaming Primary Key AutoValue feature fails" href="https://bugs.documentfoundation.org/show_bug.cgi?id=108058">bug 108058</a> from <a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> Alex Thurgood</a> <pre>(In reply to Howard Johnson from <a href="show_bug.cgi?id=108058#c0">comment #0</a>) > The only way I have found to fix this is to delete the table and start over. No, that shouldn't be necessary, just delete the Primary Key from the table in the UI, then use an ALTER TABLE statement via the Tools > SQL menu entry : <a href="http://ooo-forums.apache.org/en/forum/viewtopic.php?f=61&t=64482#p286456">http://ooo-forums.apache.org/en/forum/viewtopic.php?f=61&t=64482#p286456</a> > > This is a very basic malfunction that a new Base user will likely run into. This is a well documented known limitation, as the above link shows. If you still have a problem with the auto increment function not working once you have deleted the primary key from the table, then issued the ALTER TABLE command, there might be reason to file a bug report for that.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>