changing varchar to int

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux