Removing NOT NULL Contraint

Поиск
Список
Период
Сортировка
Искать
От
Matthew
Тема
Removing NOT NULL Contraint
Дата
в 12:20:35
Msg-id
183FA749499ED311B6550000F87E206C0C9163@SRV
Список
Дерево обсуждения
Re: Removing NOT NULL Contraint "Vladimir V. Zolotych" <gsmith@eurocom.od.ua>
I may be missing something simple here, but I have an attribute in a
table that was created as NOT NULL.  I now need to remove this
constraint.  I don't see a proper way to do this.  I think I can update
the pg_attribute table and change attnotnull from true to false.  Is
this an acceptable solution or is there a good reason that I should not
directly edit the system tables?

Maybe I'm missing something but I didn't see another way to do it other
then creating a new table, selecting into it and dropping the old table,
which seems like a lot of work for something so simple.

Thanks,

Matt
В списке pgsql-admin по дате отправления
От: bangh
Дата:
Сообщение: Re: backup of my database...
От: Todd Turner
Дата:
Сообщение: database copy and move
FAQ