12.12.2012 14:41, hjcats59 wrote:

>
> In the Firebird 2.5.2 release notes it is strongly advised to migrate
> databases using gbak backup/restore. or `If this is impracticable, at
> least rebuild all compound indices in the databases being migrated.'
>
> What's the reason for this advise, what can go wrong when indexes are
> not rebuilt?

The reason is to ensure that your data is safe and consistent.

> Is it because of http://tracker.firebirdsql.org/browse/CORE-3675

Yes but not only.

> And if so would it be enough to rebuild indexes with these characteristics:
> - Compound
> - At least one character column where nulls are allowed

Correct.

> - Unique

Incorrect.


Dmitry