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.
| Summary: | Cannot delete primary index | ||
|---|---|---|---|
| Product: | db | Reporter: | Martin Schovanek <mschovanek> |
| Component: | Code | Assignee: | Libor Fischmeistr <lfischmeistr> |
| Status: | NEW --- | ||
| Severity: | blocker | ||
| Priority: | P4 | ||
| Version: | 3.x | ||
| Hardware: | Other | ||
| OS: | Linux | ||
| Issue Type: | DEFECT | Exception Reporter: | |
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. 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. Reassigned to new owner. |
[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