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: | PointBase:Table Deletion referenced by FK contraints throws Unexpected Exception | ||
---|---|---|---|
Product: | db | Reporter: | issues@www <issues> |
Component: | Code | Assignee: | Pavel Flaska <pflaska> |
Status: | VERIFIED WORKSFORME | ||
Severity: | blocker | ||
Priority: | P3 | ||
Version: | 3.x | ||
Hardware: | Sun | ||
OS: | Other | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
issues@www
2001-09-12 15:17:20 UTC
Reassigning to Pavel, enjoy it :-) Cannot reproduce in current build. It is possible to execute drop table command on table which is referenced from another table. The foreign key in second table is dropped also. See example: create table table1 ( id1 integer not null, col1 integer not null, constraint pk_table1 primary key(id1) ); create table table2 ( id2 integer not null, col2 integer not null, constraint pk_table2 primary key(id2), constraint fk_table2_table1 foreign key(id2) references table1 ); It is possible to drop referenced table either by command "drop table table1" or by table popup action "Delete". It works without exception. It is probably related to a new version of PointBase server. I cannot reproduce it. You didn't attach script. If you will see problem again, feel free to reopen this bug. VERIFIED |