| Subject | Re: [firebird-support] Re: 2.5.1 upgrade dilemma |
|---|---|
| Author | |
| Post date | 2015-08-22T17:35:39Z |
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?
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 ; !!
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 ; !!