> Hi vlad
>
> i have relay same problem about index in FB

You have absolutely another issue, as i can see from your (almost not understandable) e-mails.

> finally decide migrate from firebird to postgresql or oracle(seems must)

Good luck

> 1.if firebird must need grow to enterprise space first solve some background problem such ans index errors
> 2.if firebird don't support online change of dml then i think is not one *enterprise* RDBMS and is only one workgroup DB.....

I don't understand what you mean

> if some action (such as change dml) in online DB is wrong FB must do raise error and dont do it....

Example ?

> but you think about change table A without any relation to table B ...doing some fault in B !

Example ??

> i dont understand why can not chnge table struct and add own field to table A when users only work with table B ?

Example ???

> i do up dramatically with postgresql in other project and have not *any* problem .....
>
> accept reality sometimes HARD !

Agree. And seems you have promlems with it, or i can't understand you completely.

Good luck with PG\ORACLE\etc...
Vlad