Issue 47981 - "Attempt to drop primary key in statement..."
Summary: "Attempt to drop primary key in statement..."
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m91
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-04-22 17:48 UTC by alvarezp2000
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.