Issue 47981

Summary: "Attempt to drop primary key in statement..."
Product: Base Reporter: alvarezp2000 <octalaoobug>
Component: codeAssignee: marc.neumann
Status: CLOSED FIXED QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: 680m91   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description alvarezp2000 2005-04-22 17:48:27 UTC
Attempt to drop primary key in statement [ALTER TABLE "Table1" DROP "id"]

This message appears when I have table "Table1" with a PK named "id", and I:
1. Open it for editing.
2. Delete the "id" row. "Oops, I made a boo-boo, I want to put it back again."
3. Add "id" row again (as a new row). Make it the appropriate data type.
4. Set it as PK.
5. Save the table. OOo won't let me. :'(

I can't even go to "Index design" because I would need to save the table first.
Comment 1 marc.neumann 2005-04-25 09:04:21 UTC
Hi,

I can't reproduce this in m95. Between m91 and m95 there are some fixes in the
hsql database.

So I close this issue as FIXED. Feel free to reopen this issue if the issue
still exits in m95

Bye Marc
Comment 2 marc.neumann 2005-04-25 09:04:44 UTC
close
Comment 3 alvarezp2000 2005-04-25 20:57:09 UTC
Confirmed as FIXED in the HSQL embedded database that I was working on. Thank 
you.