Re: Add a NOT NULL column with default only during add

Поиск
Список
Период
Сортировка
От BladeOfLight16
Тема Re: Add a NOT NULL column with default only during add
Дата
Msg-id CA+=1U=ViG6NnZCSPUXqyJ9uc4rc4ZLLqdkn3Qfdd2eU5ZBmWpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add a NOT NULL column with default only during add  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Add a NOT NULL column with default only during add  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Aug 1, 2013 at 7:53 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
It fails because

ALTER TABLE x
ADD COLUMN data2 VARCHAR(10) NOT NULL DEFAULT 'foo',

end in , instead of ;

You have to add the column before you can alter it.

=/ That's the way I have it in the SQL Fiddle sample I provided. I was asking what Mr. Broersma was suggesting.

I appreciate the effort by both of you, but it seems my points aren't getting across. Is there something more I can do to clarify?

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Add a NOT NULL column with default only during add
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Add a NOT NULL column with default only during add