Re: RI violated, bug or feature?

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