Bertram Scharpf <lists@xxxxxxxxxxxxxxxxxx> writes: > Is there a deeper reason why the foreign key allows not > referenced non-null values The SQL spec says so. Use MATCH FULL to get the behavior you want. regards, tom lane
Bertram Scharpf <lists@xxxxxxxxxxxxxxxxxx> writes: > Is there a deeper reason why the foreign key allows not > referenced non-null values The SQL spec says so. Use MATCH FULL to get the behavior you want. regards, tom lane