"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