What to watch out for when ALTERing NUMERIC(38,0) to BIGINT?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: What to watch out for when ALTERing NUMERIC(38,0) to BIGINT?
Date: 2022-07-28 15:13:10
Message-ID: a4465ae0-574a-1727-fcdd-1dac49b874c0@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2022-07-28 15:19:38 Re: What to watch out for when ALTERing NUMERIC(38,0) to BIGINT?
Previous Message Pascal CROZET 2022-07-28 14:45:38 pg 12 \if unwanted message