I tried to create a primary key on an existing table, but it is not saved.
Steps to reproduce:
1) create a Database and a new table without a primary key in it.
2) save it.
3) An error message is popped up:
"No Primary Key .. Should a primary key be created ,yet?"
3) select "No"
4) enter the edit mode again for this table
5) The primary key is lost.
I have tested this. Seems to be a bug since the start of LO. Doesn't work in LO 3.3.4, LO 188.8.131.52 and LO 184.108.40.206 under OpenSuSE 11.4 32 bit rpm. You couldn't change a table without primary-key to a table with primary key in the GUI.
Only possibility to add a primary-key is to use
Extras → SQL
ALTER TABLE "Tablename" ADD PRIMARY KEY ("Fieldname")
I set this bug to "New" and the Version to 3.3.4.
Robert: dup of fdo#49708 (see https://bugs.freedesktop.org/show_bug.cgi?id=49708) or just see also?
(In reply to comment #2)
> Robert: dup of fdo#49708 (see
> https://bugs.freedesktop.org/show_bug.cgi?id=49708) or just see also?
It's the same problem. Primary key couldn't be added by the GUI, when the table exists without a primary key.
Problem in 49708 was also, that the setting of primary key in the import-wizard is a little bit hidden.
I set this bug to duplicate of 49708.
*** This bug has been marked as a duplicate of bug 49708 ***