[Libreoffice-bugs] [Bug 49708] EDITING FILESAVE Setting primary key was silently ignored

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Sun Jul 8 11:45:41 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=49708

robert at familiegrosskopf.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
           Severity|critical                    |normal
                 CC|                            |robert at familiegrosskopf.de
     Ever Confirmed|0                           |1

--- Comment #1 from robert at familiegrosskopf.de 2012-07-08 09:45:41 UTC ---
When you import data from calc and follow the import-wizard you could set the
primary-key for the column you wish. Also you could set the right property of
the field.
When you try to import tables and ignore the wizard (choosing "Create" in the
first step of the wizard), the primary-key couldn't be set later in the GUI.
This is a bug.
You could set the key in SQL with

ALTER TABLE "tablename" ADD PRIMARY KEY ("columnname");

Changed the Status to "new", the Importance to "normal" (because there is a
possibility to use the whole wizard and change to primary-key there and a
possibility in direct SQL)

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list