Emil Rachovsky <zsevgymko@xxxxxxxxx> writes: > I am trying to find the equivalent of these two > Sybase system columns : > check_on_commit (Y/N) - Indicates whether INSERT and > UPDATE commands should wait until the next COMMIT > command to check if foreign keys are valid. I think you are looking for the DEFERRABLE/DEFERRED option of foreign key constraints. > nulls (Y/N) - Indicates whether the columns in the > foreign key are allowed to contain the NULL value. > Note that this setting is independent of the nulls > setting in the columns contained in the foreign key. No such animal in the SQL standard --- though perhaps MATCH FULL is approximately what you are looking for? Your description as stated makes no sense at all; either the columns are allowed to be null, or they're not. regards, tom lane
