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

[bugzilla-daemon at freedesktop.org]

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

Ulf Zibis <Ulf.Zibis at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |critical
           See Also|                            |https://bugs.freedesktop.or
                   |                            |g/show_bug.cgi?id=51872

--- Comment #2 from Ulf Zibis <Ulf.Zibis at gmx.de> 2012-07-08 12:03:45 PDT ---
(In reply to comment #1)
> When you import data from calc and follow the import-wizard you could set the
> primary-key for the column you wish.

No, if I choose the existing column 'ID', I get the error, "There are already
following fields set as primary key: ID".
I only can choose an additional primary key field, which is worthless.

> Also you could set the right property of the field.

I don't see any possibility to set field properties in the wizard, I only can
set the data type/length.

> You could set the key in SQL with
> 
> ALTER TABLE "tablename" ADD PRIMARY KEY ("columnname");

Sorry, I can't see, from where to run such SQL statement, please help.

Changed the Importance again to "critical" (because none of the given
workarounds seem to work).

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