Re: RI violated, bug or feature? - Mailing list pgsql-general

From Tom Lane
Subject Re: RI violated, bug or feature?
Date
Msg-id 3392.971556002@sss.pgh.pa.us
Whole thread Raw
In response to RI violated, bug or feature?  (100.179370@germanynet.de (Martin Jacobs))
List pgsql-general
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

pgsql-general by date:

Previous
From: 100.179370@germanynet.de (Martin Jacobs)
Date:
Subject: RI violated, bug or feature?
Next
From: Collin Peters
Date:
Subject: JDBC Driver homepage down