Subject | Re: [firebird-support] Re: Fixing a varchar field |
---|---|
Author | Ann W. Harrison |
Post date | 2009-04-03T17:04:49Z |
eddressel wrote:
your database. There are no sanity checks built into the
system tables - put in bad data and your database is garbage.
The ability to update the system tables directly seemed like
a good idea 25 years ago. We were wrong, but it did have
an interesting symmetry.
In short, don't do it, and if you do, don't expect sympathy.
Cheers,
Ann
>No, because it would break other things.
> If I report this--are you going to take the feature away :-0
>Direct system table updates are a classic way to screw up
> I found out how to do this via IB Expert:
>
> update RDB$RELATION_FIELDS
> set RDB$FIELD_SOURCE = 'DM_STR30'
> where (RDB$FIELD_NAME = '<Field Name>')
> and (RDB$RELATION_NAME = '<TableName')
your database. There are no sanity checks built into the
system tables - put in bad data and your database is garbage.
The ability to update the system tables directly seemed like
a good idea 25 years ago. We were wrong, but it did have
an interesting symmetry.
In short, don't do it, and if you do, don't expect sympathy.
Cheers,
Ann