> Yes. The id is stored as uuid. Thanks for the suggestion. Should work > > > On Wed, Oct 7, 2020 at 7:27 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > 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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> >