Why ? The table "folder" cannot be dropped. It is referred to from the table "mail"

Why can't I understand this?
Ad Franse

NexusDB: Query26344411: Query execution failed:
Unexpected exception object raised: [Exception] The table "folder" cannot be
dropped. It is referred to from the table "mail" [$3CA1/15521]


create a new database,
execute the following code in EM 2.06.01 with server 2.06.01 or 2.06.02
(dayly 04.05.2007)


drop table if exists folder;
create table folder
(
folder_id autoinc primary key
);

drop table if exists mail;
drop table if exists mail_folder;
create table mail_folder
(
mail_folder_id autoinc primary key
);

drop table if exists mail;
create table mail
(
mail_id autoinc primary key,
mail_folder_id integer references mail_folder
(mail_folder_id)
);

Ad Franse wrote:

> Why can't I understand this?
> Ad Franse
>
> NexusDB: Query26344411: Query execution failed:
> Unexpected exception object raised: [Exception] The table "folder"
> cannot be dropped. It is referred to from the table "mail"
> [$3CA1/15521]

There is referential integrity in place linking folder and mail. It
needs to be removed first.

--

>> NexusDB: Query26344411: Query execution failed:
>> Unexpected exception object raised: [Exception] The table "folder"
>> cannot be dropped. It is referred to from the table "mail"
>> [$3CA1/15521]
>
> There is referential integrity in place linking folder and mail. It
> needs to be removed first.

Yes, that's what I understand.

this is folder :

create table folder
(
folder_id autoinc primary key
);

this is mail:

create table mail
(
mail_id autoinc primary key,
mail_folder_id integer references mail_folder
(mail_folder_id)
);

I think that it is referring to mail_folder not folder what do you think ?

Ad Franse

> Unexpected exception object raised: [Exception] The table "folder"
> cannot be dropped. It is referred to from the table "mail"
> [$3CA1/15521]

Yeah, something is wrong here, issue #2431.

--

Eivind Bakkestuen
Nexus Database Systems Pty Ltd

I confirm that today's snapshot solves this problem.
Thanks !

Ad


"Eivind Bakkestuen [NDD]" <Ieivind.bakkestuenHATE@nexusdb.comSPAM> wrote in
message news:463c447c@wic040d....
>> Unexpected exception object raised: [Exception] The table "folder"
>> cannot be dropped. It is referred to from the table "mail"
>> [$3CA1/15521]
>
> Yeah, something is wrong here, issue #2431.
>
> --
>
> Eivind Bakkestuen
> Nexus Database Systems Pty Ltd
>