Tested on Ubuntu 11.04, Libo3.5 RC2, Postgres 8.4 and 9.1 Open an ODB connected to a psql server. Open a table property dialog for a table w/o a Primary Key No way to create one.
Confirmed. Setting to "enhancement" since AFAIK this never worked with PostgreSQL-SDBC in the past. Setting low priority as I'm going to focus on data manipulation issues before data definition issues. (data definition can conceivably be done with SQL statements rather than GUI and/or separate PostgreSQL-specific GUI).
same situation with the new table wizard, the set primary key ability is never displayed. Would you prefer I open a new issue?
(In reply to comment #2) > same situation with the new table wizard, the set primary key ability is never > displayed. > Would you prefer I open a new issue? Nah, it is most probably all the same bug and root cause.
I got this message in the console when I saved a table definition using the Table Designer in my 32bit build from LO master (08/02/2013) : NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "country_pkey" for table "country" and a primary key was automatically created on the INT(4) field. There is however something strange here : although I used the GUI to specify that this field should be autoincremented, and although it seemed to accept that value and save it as such, in reality it did not, and the first time I tried to enter data into the table by Tab switching from the INT field to my varchar fields, I got an error on saving the tuple, with postgres complaining about a field mismatch. When I checked the table definition again, I saw that the SERIAL function had not been set on that field. Will open a separate bug report against that. Alex
You could not change any field in a created table using PostgreSQL and SDBC (and also with other external databases). I have tested the following: Tools → SQL CREATE TABLE test ( id INT, name VARCHAR(50) ); Refreshed the table-container. Opened the table for changing. Added a field and switched it to primary-key. Works. My system: LO 4.1.0.4, OpenSUSE 12.3 64bit rpm
(In reply to comment #5) > You could not change any field in a created table using PostgreSQL and SDBC. > I have tested the following: > Tools → SQL > CREATE TABLE test ( id INT, name VARCHAR(50) ); > Refreshed the table-container. > Opened the table for changing. > Added a field and switched it to primary-key. > Works. I'm not sure I understand completely. Are you saying this bug is fixed?
(In reply to comment #6) > (In reply to comment #5) > > You could not change any field in a created table using PostgreSQL and SDBC. > > I have tested the following: > > Tools → SQL > > CREATE TABLE test ( id INT, name VARCHAR(50) ); > > Refreshed the table-container. > > Opened the table for changing. > > Added a field and switched it to primary-key. > > Works. > > I'm not sure I understand completely. Are you saying this bug is fixed? I have understand the description as followed: It is impossible to set a primary-key in the table editor for a table, which hasn't a primary key. I have tested this with PostgreSQL and the direct driver. I could create a new field in the table and set this field to a primary key. I'm using LO 4.1.0.4. Could it be the same reason like https://bugs.freedesktop.org/show_bug.cgi?id=49708 ? It doesn't work in LO 4.0.3.3!
(In reply to comment #7) > (In reply to comment #6) >> I'm not sure I understand completely. Are you saying this bug is fixed? > I have understand the description as followed: > I have tested this with PostgreSQL and the direct > driver. I could create a new field in the table and set this field to a > primary key. I'm using LO 4.1.0.4. > Could it be the same reason like > https://bugs.freedesktop.org/show_bug.cgi?id=49708 ? Probably. Assuming it is. If anybody can still reproduce with LibreOffice 4.1.0.2 or later or with LibreOffice 4.0.5, then reopen. *** This bug has been marked as a duplicate of bug 49708 ***