If you specify RESTRICT, PSQL enforces the DELETE RESTRICT rule. A user cannot delete a row in the parent table if a foreign key value refers to it.

If you do not specify a delete rule, PSQL applies the RESTRICT rule by default.

ALTER TABLE