RE: [Firebird-devel] BEta 3- ODS version

[Dmitry Y. <di...@us...>]

Didier,

> I have noticed doing a gstat on one of my existing databases that the
> ODS version is 10.1.
>
> Since I have replaced 1.02 with 1.5 on my dev box I cannot
> check now but I though that up to 1.02 ODS was 10.

Yes, FB 1.0.x uses ODS 10.0, whilst FB 1.5 has ODS 10.1.

> questions:
>    . has 1.5 changed anything to the DB structure ?

No, minor ODS changes just mean additional system indices and/or triggers.
No changes in the FB structure.

>    . if I had to revert back to 1.02 would I be able to ?

Generally, yes. But if you create constraints in v1.5, you may have some
problems after reverting back to 1.02 (because of the bug in FB 1.0.x which
is fixed in FB 1.5).

>    . because of this ODS change, is the preferred route for
> upgrade is to gbak in 1.02 & restore in 1.5 ?

Backup/restore is always the best way, although for v1.5 it's not required
(ODS will be upgraded automatically at the first attachment). But since
there were some bugs fixed in the existing system triggers, using
backup/restore is highly recommended.


Dmitry