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 <adrian.kla...@aklaver.com> 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 <adrian.kla...@aklaver.com > > <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
