Subject RE: [ib-support] Direct modification to system tables to...
Author Kaputnik
This shouldn't be a problem....
Just tried it with a 4GB database, and everything seems fine here
(queries on the affected table were running smoothly)
Don't know how indizes on the affected columns could be affected,
Other question:
Why don't you do this with simple ddl, as changing the domain of a
table's field is part of standard ddl? (ALTER TABLE table ALTER field
TYPE domain)

> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Tuesday, July 10, 2001 8:55 AM
> To:
> Subject: Re: [ib-support] Direct modification to system tables to...
> > most of the IB administration Systems do it right this way:
> >
> > update RDB$FIELDS set
> > where RDB$FIELD_NAME = xx
> >
> > I never experienced any problem with this....
> Nor have I but in my case I am doing this:
> WHERE ...
> This takes a column and changes it from one domain to another domain.
> I cannot change the type of the domain because other columns defined
> it
> need to remain as they are.
> Thanks for any additional comments.
> PS. It does seem to be working without any fireworks.
> Jason Wharton
> CPS - Mesa AZ