I need to change the not-null restriction on some columns in a table,
and this doesn't seem to be possible with ALTER TABLE. Is it safe to
connect as superuser and update pg_attribute.attnotnull directly? Or
is there a different way to do this, other than dropping/re-creating
the whole table?
I'm currently running 7.2.3, but will be upgrading soon so I'd like to
know if this would work with 7.3 as well.
Thanks!
Bob Smith
Hammett & Edison, Inc.
bsmith@h-e.com