Re: Increasing a NUMERIC column precision doesn't cause a table rewrite. Why? - Mailing list pgsql-general

From Weck, Luis
Subject Re: Increasing a NUMERIC column precision doesn't cause a table rewrite. Why?
Date
Msg-id IA3PR10MB8113ACB1FED522A1EC00FAF28DC7A@IA3PR10MB8113.namprd10.prod.outlook.com
Whole thread Raw
In response to Increasing a NUMERIC column precision doesn't cause a table rewrite. Why?  (Marcelo Fernandes <marcefern7@gmail.com>)
List pgsql-general
My understanding is that Postgres can guarantee that all the values in the table will fit the new precision without having to check. If you change the scale, it might be the case that some values won’t fit anymore, and Postgres must return an error. Numeric by itself is a variable length type, like TEXT (in a sense). That’s why we can modify its size without requiring a table rewrite at all!

pgsql-general by date:

Previous
From: "Weck, Luis"
Date:
Subject: Re: Increasing a NUMERIC column precision doesn't cause a table rewrite. Why?
Next
From: Bruce Momjian
Date:
Subject: Re: Enquiry about TDE with PgSQL