The foreign key constraint can be deferred. Set the referencing column(s) to their default values.Ĭheck this option to not allow one column of a multicolumn foreign key to be null unless all foreign key columns are null. This is the default action.ĭelete any rows referencing the deleted row, or update the value of the referencing column to the new value of the referenced column, respectively. If the constraint is deferred, this error will be produced at constraint check time if there still exist any referencing rows. Produce an error indicating that the deletion or update would create a foreign key constraint violation. This is the same as NO ACTION except that the check is not deferrable.

The On Delete and On Update drop-down list define the type of the actions to be taken.

To include field(s)/referenced field(s) to the key, just simply double-click the Fields/ Referenced Fields field or click to open the editor(s) for editing. Use the Referenced Schema and Referenced Table drop-down lists to select a foreign schema and table respectively. Use the Name edit box to enter a name for the new key.

Navicat pgsql