Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] change type from NUMERIC(14,4) to NUMERIC(24,12) - Mailing list pgsql-general

From Torsten Förtsch
Subject [GENERAL] change type from NUMERIC(14,4) to NUMERIC(24,12)
Date
Msg-id CAKkG4_nN5b_ktJS1Y3aZwxNn8KFvYKPOvW1Q6L+cybf4YD9X=g@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [GENERAL] Detailed progress reporting for "vacuuming indexes" stage
Next
From: Albe Laurenz
Date:
Subject: Re: [GENERAL] change type from NUMERIC(14,4) to NUMERIC(24,12)