Re: Foreign keys and null - Mailing list pgsql-novice

From Oliver Fromme
Subject Re: Foreign keys and null
Date
Msg-id 200309291244.h8TCi35u027582@lurza.secnetix.de
Whole thread Raw
In response to Foreign keys and null  (Oliver Fromme <olli@lurza.secnetix.de>)
Responses Re: Foreign keys and null  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Uhm, sorry for the noise, but the problem solved itself,
kind of ...

I wasn't aware that a foreign key actually _can_ be null.

The docs weren't very specific about that.  Thinking that
a foreign key must contain a valid reference to another
table (after all, that's what a foreign key is for), I
implied that it cannot be null -- which was wrong.

Thanks for listening anyway.  :-)

Regards
   Oliver

--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

With Perl you can manipulate text, interact with programs, talk over
networks, drive Web pages, perform arbitrary precision arithmetic,
and write programs that look like Snoopy swearing.

pgsql-novice by date:

Previous
From: Oliver Fromme
Date:
Subject: Foreign keys and null
Next
From: "David Benoff"
Date:
Subject: Computed columns and functions?