Customers
PostgreSQL Maestro online Help
Prev  |
Return to chapter overview | Next  |
Setting other forein key properties
Match type
A value inserted into the referencing column(s) is matched against the values of the referenced table and referenced columns using the given match type.
| • | Match Full will not allow one column of a multi-column foreign key to be null unless all foreign key columns are null. |
| • | Match Simple, which is also the default, allows some foreign key columns to be null while other parts of the foreign key are not null. |
Deferrable
This controls whether the constraint can be deferred. A constraint that is not deferrable will be checked immediately after every command. Checking of foreign key constraints that are deferrable may be postponed until the end of the transaction.
Comment
The box allows you to set optional text describing the foreign key.
| Prev |
Return to chapter overview | Next |
