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

Поиск
Список
Период
Сортировка
От Torsten Förtsch
Тема [GENERAL] change type from NUMERIC(14,4) to NUMERIC(24,12)
Дата
Msg-id CAKkG4_nN5b_ktJS1Y3aZwxNn8KFvYKPOvW1Q6L+cybf4YD9X=g@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] change type from NUMERIC(14,4) to NUMERIC(24,12)  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: [GENERAL] change type from NUMERIC(14,4) to NUMERIC(24,12)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [GENERAL] Detailed progress reporting for "vacuuming indexes" stage
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: [GENERAL] change type from NUMERIC(14,4) to NUMERIC(24,12)