Subject | Re: [ib-support] Direct modification to system tables to... |
---|---|
Author | Jason Wharton |
Post date | 2001-07-10T07:08:20Z |
Nick,
It is always a good idea to clear away constraints and indexes whenever
tinkering with system relations.
I removed all indexes that were tangled in with the affected columns.
Thanks for your thoughts. I think it is going to fly.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
> This shouldn't be a problem....I'm working with a legacy database on IB 5.6.
> 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,
> though.
> 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)
It is always a good idea to clear away constraints and indexes whenever
tinkering with system relations.
I removed all indexes that were tangled in with the affected columns.
Thanks for your thoughts. I think it is going to fly.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com