Re: changing varchar to int
| От | Matheus de Oliveira |
|---|---|
| Тема | Re: changing varchar to int |
| Дата | |
| Msg-id | CAJghg4Lthay_SvQNdCu6R486_zk-Wq0LFYH3-tp26dOjuH4hew@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: changing varchar to int (Ian Barwick <ian@2ndquadrant.com>) |
| Список | pgsql-admin |
On Thu, Jul 23, 2015 at 6:41 AM, Ian Barwick <ian@2ndquadrant.com> wrote:
You'll need to drop the column default and re-add it after converting the> 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
column.
You are correct, but in this specific case I don't see much point of having a DEFAULT NULL anyway (NULL is already the default, when there is no DEFAULT [confusing? xD ]). I'd just drop the DEFAULT and then change the type:
ALTER TABLE device
ALTER model DROP DEFAULT,
ALTER model TYPE integer USING (model::integer);
ALTER model DROP DEFAULT,
ALTER model TYPE integer USING (model::integer);
Regards,
--
Matheus de Oliveira
В списке pgsql-admin по дате отправления: