Subject Re: [firebird-support] Change Datatype (2)
Author Ann W. Harrison
At 11:11 AM 10/22/2004, Martijn Tonies wrote:

>Firebird disallows this change because of the automagically
>created indices for PKs. FKs can point to a PK.

Hunh? A single firebird index can have both smallin and int
values in it - no problem. Numeric indexes - except int64 due
to an unfortunate implementation decision - are all double
precision precisely to allow users to change the size and scale
of numeric fields.