Hi Adrian,
I use use IBExpert as well but I do not think it is caused by IBExpert. If
you looked properly, you would see, that IBExpert issued 2 commands - "drop
constraint" and "create constraint". Example from my db:
?
ALTER TABLE CASH_OUT_ITEMS DROP CONSTRAINT FK_CASH_OUT_ITEMS__CASH_OUT;

alter table CASH_OUT_ITEMS
add constraint FK_CASH_OUT_ITEMS__CASH_OUT
foreign key (CSO_ID)
references CASH_OUT(CSO_ID)
on delete CASCADE;

This should be problem with Firebird, I guess.
Ales

> -----Original Message-----
> From: Adrian Roman [mailto:aroman@...]
> Sent: Monday, July 29, 2002 1:24 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Index unexpectedly deleted?
>
>
> > How did you change this?
>
> Well, I could reproduce the problem!
>
> I use IBExpert personal edition v 2.00.5.
> I think it's the tool's fault along with FB's fault.
> IBExpert should drop the previous constraint or alter it, but
> instead it
> adds another one with the same name.
> The change was done with:
>
> alter table "Operatii"
> add constraint "FK_OperatiiDocument"
> foreign key ("Document")
> references "Documente"("Document")
> on update CASCADE
>
> The constraint was added previously with
>
> alter table "Operatii"
> add constraint "FK_OperatiiDocument"
> foreign key ("Document")
> references "Documente"("Document")
>
>
> I wonder why FB allows adding a new constraint with the same name?
>
>
> Adrian Roman
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Free $5 Love Reading
> Risk Free!
> http://us.click.yahoo.com/NsdPZD/PfREAA/Ey.GAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/