To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108303
User atjensen changed the following:
What |Old value |New value
================================================================================
Assigned to|dbaneedsconfirm |oj
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Summary|Base: Primkey can not be s|Base: Primkey can not be s
|et |et for existing columns vi
| |a GUI table editor
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Mon Mar 8 00:29:39
+0000 2010 -------
oh and one correction - adding an auto_increment integer field to an existing
table does indeed, fill all existing records with proper values. So you can do
both steps in the table editor without a problem.
Again - I am using XP and OOo 3.2
Changed summary for PK problem
Confirmed and assign to developer
Finally the problem is that a drop primary key is issued without If EXISTS.
However you can assign Primary Key to an existing table column using the SQL DDL
in the SQL window.
so given a table with an column id you can make that the PK with
ALTER TABLE "Table1" ADD PRIMARY KEY ("id" )
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
