Content-Type: multipart/alternative;
 boundary="------------C689zDZQlPA5mKTLq0lQSBQM"
Message-ID: <a4465ae0-574a-1727-fcdd-1dac49b874c0@gmail.com>
Date: Thu, 28 Jul 2022 10:13:10 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.9.1
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Language: en-US
From: Ron <ronljohnsonjr@gmail.com>
Subject: What to watch out for when ALTERing NUMERIC(38,0) to BIGINT?
Archived-At: 
 <https://www.postgresql.org/message-id/a4465ae0-574a-1727-fcdd-1dac49b874c0%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------C689zDZQlPA5mKTLq0lQSBQM
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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.
--------------C689zDZQlPA5mKTLq0lQSBQM
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    AWS RDS Postgresql 12.10<br>
    <br>
    <br>
    We've got tables with columns of data type NUMERIC(38,0) which are a
    legacy from an Oracle migration.<br>
    <br>
    Besides what's mentioned in
    <a class="moz-txt-link-freetext" href="https://www.postgresql.org/docs/12/ddl-alter.html#id-1.5.4.8.10">https://www.postgresql.org/docs/12/ddl-alter.html#id-1.5.4.8.10</a>,
    what happens <b>internally</b> when I run:<br>
    ALTER TABLE foo ALTER COLUMN bar TYPE BIGINT;<br>
    <br>
    I'm thinking mostly of record fragmentation.<br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------C689zDZQlPA5mKTLq0lQSBQM--