"Tamsin" <tg_mail(at)bryncadfan(dot)co(dot)uk> writes:
> I want to remove a not null constraint from a table. I've read the posts
> about having to rename, recreate without not nulls & insert back into the
> table. This is fine, but the table also has a lot of foreign keys/rules etc
> & recreating all these is a bit of pain.
> I tried updating pg_attribute & setting attnotnull to 'f' for the field in
> question. This seems to have worked. Is it safe?! - is there anything else
> I should be aware of?
Yup, that should do the trick. Not much magic here...
regards, tom lane