What to watch out for when ALTERing NUMERIC(38,0) to BIGINT? - Mailing list pgsql-admin

From Ron
Subject What to watch out for when ALTERing NUMERIC(38,0) to BIGINT?
Date
Msg-id a4465ae0-574a-1727-fcdd-1dac49b874c0@gmail.com
Whole thread Raw
Responses Re: What to watch out for when ALTERing NUMERIC(38,0) to BIGINT?
List pgsql-admin
AWS RDS Postgresql 12.10


We've got tables with columns of data type NUMERIC(38,0) which are a legacy from an Oracle migration.

Besides what's mentioned in https://www.postgresql.org/docs/12/ddl-alter.html#id-1.5.4.8.10, what happens internally when I run:
ALTER TABLE foo ALTER COLUMN bar TYPE BIGINT;

I'm thinking mostly of record fragmentation.

--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: Pascal CROZET
Date:
Subject: pg 12 \if unwanted message
Next
From: "David G. Johnston"
Date:
Subject: Re: What to watch out for when ALTERing NUMERIC(38,0) to BIGINT?