Re: lost in system tables

On Tuesday 06 December 2005 08:47, Emil Rachovsky wrote:
> 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. A foreign
> key is valid if, for each row in the foreign table,
> the values in the columns of the foreign key either
> contain the NULL value or match the primary key values
> in some row of the primary table.
>
> 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.
>
> Maybe pg_constaint.condeferrable is appropriate for
> check_on_commit? I'll appreciate any help
>
> Thanks in advance,
> Emil

Those parameters are specified when you declare the foreign key. Look here,
in the section describing "references":
http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html

Luca