This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 36621 - Cannot delete primary index
Summary: Cannot delete primary index
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 3.x
Hardware: Other Linux
: P4 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-10-15 14:32 UTC by Martin Schovanek
Modified: 2014-01-07 10:36 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

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

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Schovanek 2003-10-15 14:32:53 UTC 
[Nb Build 200310150100, Oracle Thin]      
      
DB Explorer generates command like:     
'drop index "SCOTT"."a_PK"'     
which throws err:   ORA-02429 cannot drop index 
used for enforcement of unique/primary key 
 
it should be:     
'ALTER TABLE "AA" DROP CONSTRAINT'    
"a_PK"     
     
see ORA-02429 on:    
http://mirrors.spb.ru/oracledocs/server/msg73/ch232.html
Comment 1 Radko Najman 2003-10-20 14:00:14 UTC 
Design issue. Not possible to easily fix because of the limitation of
dbspec.plist file.
It needs to define two commands for index node and then decide if it
is a PK or ordinary index and execute the right command.
Comment 2 David Vancouvering 2008-11-12 17:32:28 UTC 
This requires a re-architecture to use something like DDLUtils rather than dbspec.plist.  Let's see if we can fix this
in the next release.
Comment 3 Jiri Rechtacek 2009-02-10 15:20:43 UTC 
Reassigned to new owner.