change type from NUMERIC(14,4) to NUMERIC(24,12)

[Torsten Förtsch <tfoertsch123@xxxxxxxxx>]

Hi,

we have a large table and want to change the type of one column from NUMERIC(14,4) to NUMERIC(24,12). If the new type is just NUMERIC without any boundaries, the operation is fast. If (24,12) is specified, it takes ages.

I think it takes so long because the database wants to check that all data in the table is compatible with the new type. But the old type has stricter boundaries both before and after the dot. So, it is compatible. It has to be.

Is there a way to change the type skipping the additional check?

This is 9.6.

Thanks,

Torsten