[Libreoffice-bugs] [Bug 108058] After renaming Primary Key AutoValue feature fails

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108058

--- Comment #1 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to Howard Johnson from comment #0)


> 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 :


http://ooo-forums.apache.org/en/forum/viewtopic.php?f=61&t=64482#p286456




> 
> 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170524/ad52049c/attachment.html>