To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=47321
Issue #:|47321
Summary:|cannot change existing column to be a primary key in
|bugdoc (HSQLDB)
Component:|Database access
Version:|680m93
Platform:|PC
URL:|
OS/Version:|Windows XP
Status:|NEW
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|oj
Reported by:|fs
------- Additional comments from [EMAIL PROTECTED] Wed Apr 13 01:40:46 -0700
2005 -------
- open the attached database
- open the table design "invoices"
- make the column "INVOICENO" the primary key of the table
- save the table design
=> error message:
Constraint already exists: SYS_PK_invoices in statement [ALTER TABLE "invoices"
ADD PRIMARY KEY ("INVOICENO")]
---------------------------------------------------------------------
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]
