Re: RI violated, bug or feature?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 100(dot)179370(at)germanynet(dot)de (Martin Jacobs)
Cc: PGSQL Mailinglist <pgsql-general(at)hub(dot)org>
Subject: Re: RI violated, bug or feature?
Date: 2000-10-14 20:40:02
Message-ID: 3392.971556002@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

100(dot)179370(at)germanynet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2000-10-14 22:21:04 Re: can I define own variables?
Previous Message Tom Lane 2000-10-14 16:47:07 Re: PostgreSQL man pages