Re: [firebird-support] Re: 2.5.1 upgrade dilemma

[tvd...@ymail.com [firebird-support]]

That's very interesting! Does this behavior still exist? Is there any way to 
verify that?

So basically, if I execute the following after moving from 2.5.1 to 2.5.4 I 
should be fine?

 SET TERM !! ;

EXECUTE BLOCK AS
DECLARE VARIABLE stmt VARCHAR(1000);
BEGIN
for select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where (rdb$system_flag is null or rdb$system_flag = 0)
order by rdb$foreign_key nulls first
into :stmt
do EXECUTE STATEMENT :stmt;
END!!

SET TERM ; !!