Subject | Re: [firebird-support] Problem restoring test database |
---|---|
Author | Milan Babuskov |
Post date | 2006-11-20T22:43:16Z |
Fabiano Bonin wrote:
ALTER TABLE fer1 ALTER data TYPE ps_data;
Firebird are you using?
--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org
> I'm making some tests on a database, changing system tables and otherThen why don't you use the statement that is meant for this:
> non recomended things... To more precise, i am deleting all foreign
> keys, primary keys and indices (in the right way) and changing the
> domain of some fields in the system tables (ex: update
> rdb$relation_fields set rdb$field_source = 'PS_DATA' where
> rdb$field_name = 'DATA' and rdb$relation_name = 'FER1'). The domains
> are always equal or larger in space compared to the original field
> type.
ALTER TABLE fer1 ALTER data TYPE ps_data;
> My questions are:Direct modification of system tables perhaps? ;)
> - Should i expect this kind of error with a valid backup file, that
> was done without problems?
> - What can cause this error, since the restore cycle went up to its
> end without any kind of error?
> Thanks.You forgot to mention the most important thing: which version of
Firebird are you using?
--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org