100.179370@germanynet.de (Martin Jacobs) writes:
> test_ri=> insert into books (title) values ('violated');
> INSERT 35903 1
> Hey, I have now a row in books, which has no corresponding
> publisher entry. Let's do another test:
If you don't want to allow NULLs in a referencing column, add a
NOT NULL constraint to it. Otherwise they're allowed.
regards, tom lane