Quick question -
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?
Thanks,
Tamsin