Hi, Am Dienstag, 16. Jan 2007, 15:51:58 -0500 schrieb 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. Ah, I should have seen that in the documentation. Sorry for the noise. Thanks to all, Bertram -- Bertram Scharpf Stuttgart, Deutschland/Germany http://www.bertram-scharpf.de