Re: alter the datatype of Partition Key

From: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: alter the datatype of Partition Key
Date: 2025-06-16 13:16:47
Message-ID: CAHOGQfXU5Lks_xizETjXvnENFHafT2xT3wOB0D=8X_bL_as4rA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Please help me on this

Thanks & Regards
Gambhir Singh

On Mon, 16 Jun 2025 at 12:45, Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
wrote:

> Hi,
>
> We have a partition table with partitioning type range and got the
> requirement from the application team to alter the datatype of partitioning
> key from bigint to varchar. Please suggest to me the way how this can be
> achieved.
>
> Data volume is quite huge in the table. ~50 Billion rows
>
> --
> Thanks & Regards
> Gambhir Singh
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ROHIT SACHDEVA 2025-06-16 17:56:51 Regarding Partition
Previous Message Christophe Courtois 2025-06-16 08:13:59 Re: alter the datatype of Partition Key