| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Hemil Ruparel <hemilruparel2002(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: How to migrate column type from uuid to serial |
| Date: | 2020-10-07 13:57:13 |
| Message-ID: | e06aab47-151c-ea50-36bf-a34d68337f22@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/7/20 5:48 AM, Hemil Ruparel wrote:
> I was integrating a payment gateway for my app when I noticed its
> maximum length of customer id string is 32. SIze of UUID is 36 (32
> characters and 4 dashes). So I want to change the type of customer id to
> serial. The problem is by now, the column is being used at many places.
> How to migrate the column to serial without dropping the data?
Changing the size of the column is not an option?
Your description of the customer id column above is somewhat confusing
to me. Is the id actually stored as a UUID?
Why is the max length an issue?
If you where to migrate I would say create an independent
serial/identity column. Then point the dependent objects at that. After
all have been converted drop the old column.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-10-07 13:59:40 | Re: How to migrate column type from uuid to serial |
| Previous Message | Magnus Hagander | 2020-10-07 13:53:34 | Re: What version specification used by PG community developers? |