Re: SET NULL / SET NOT NULL

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> What about temporary tables - is there any reason they shouldn't be able to
> modify a temporary table?

I don't see one.

> What about indices?  Will twiddling the nullability break indices on a table
> in any way?

No, not as long as you aren't changing existing data in the table.

> And foreign keys - foreign keys only have to reference UNIQUE, right?  The
> nullability isn't an issue?

Not sure about that --- Stephan or Jan will know.

> Lastly - in a multicolumn primary key, does EVERY column in the key need to
> be NOT NULL?

Yes, I believe so.
        regards, tom lane