Re: changing varchar to int

On 15/07/23 16:27, Ankur Kaushik wrote:
> Original column
>
>
>
> Column                   Type                                 Modifiers
> model                | character varying(50)       | default NULL::character varying
>
>
> Required Column
>
> Model                   integer
>
>
> =========
> ALTER TABLE device ALTER COLUMN model TYPE integer USING (model::integer);
>
>
> getting below error
>
> ERROR:  default for column "model" cannot be cast automatically to type integer

You'll need to drop the column default and re-add it after converting the
column.


Regards

Ian Barwick

--
 Ian Barwick                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services