"Christopher Kings-Lynne" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])