Skip site navigation (1) Skip section navigation (2)

Re: BUG #2412: Foreing key accept nulls

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Sidar Lopez Cruz <sidarlopez(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2412: Foreing key accept nulls
Date: 2006-04-29 15:42:48
Message-ID: 20060429083944.Y52950@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, 28 Apr 2006, Sidar Lopez Cruz wrote:

>
> The following bug has been logged online:
>
> Bug reference:      2412
> Logged by:          Sidar Lopez Cruz
> Email address:      sidarlopez(at)hotmail(dot)com
> PostgreSQL version: 8.1.3
> Operating system:   Ubuntu 6.04
> Description:        Foreing key accept nulls
> Details:
>
> I think that when I create table that have a foreing key to another one
> these FK may not accept nulls by default.

The SQL spec seems to say otherwise.  A foreign key constraint with match
simple (unspecified) is considered satisfied if any component of the key
is null or there is a match in the referenced table. A foreign key
constraint with match full is considered satisified if all components of
the key is null or there is a match in the referenced table. For a
single column key, this means NULLs are acceptable unless the column has
other constraints (like not null).



In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-04-29 19:34:28
Subject: Re: [BUGS] BUG #2401: spinlocks not available on amd64
Previous:From: MichaelDate: 2006-04-29 14:02:01
Subject: BUG #2414: Something is missing in the PostGre-Java-Connector

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group