Emil Rachovsky <zsevgymko@yahoo.com> 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