Yes the id is stored as a uuid. Thanks for the suggestion. Should work
On Wed, Oct 7, 2020 at 7:29 PM Adrian Klaver <[email protected]> wrote: > On 10/7/20 6:58 AM, Hemil Ruparel wrote: > > Please reply to list also. > Ccing list > > > Yes. The id is stored as uuid. Thanks for the suggestion. Should work > > > > > > On Wed, Oct 7, 2020 at 7:27 PM Adrian Klaver <[email protected] > > <mailto:[email protected]>> 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 > > [email protected] <mailto:[email protected]> > > > > > -- > Adrian Klaver > [email protected] >
