Subject Re: [firebird-support] Firebird 1.5.3 and 2.0RC2 on the same linux box
Author Flavio Costa
> --- Dimitry Sibiryakov <SD@...> wrote:
>
> >When I restore the backup to 2.0, I get the following message:
> >
> >gbak: cannot commit index FK_PERFIL_USUARIO
> >gbak: ERROR: unsuccessful metadata update
> >gbak: ERROR: partner index segment no 1 has incompatible data type
> >
> >Is there any issues doing this (using different versions of firebird
> >on same machine)? What are the necessary steps?
>
> Your problem is not two versions on the same machine. Your problem
> is in your database. FB2 is more strict and intolerant for mistakes.
> According to the error message you have string field refering to
> integer field in FK or something like this.
>
> --
> SY, Dimitry Sibiryakov.

You´re right. There was an unused column of type CHAR in the table referencing an INTEGER
column on foreign table.

Thank you.


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com