Subject Re: [firebird-support] Re: 2.5.1 upgrade dilemma
Author Carlos H. Cantu
Post date 2015-08-22T20:37:31Z
Re: [firebird-support] Re: 2.5.1 upgrade dilemma Afaik, this still works. Maybe a core-developer can confirm.

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br


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 ; !!