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
