Re: Foreign keys and null

From: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
To: olli(at)lurza(dot)secnetix(dot)de (Oliver Fromme)
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Foreign keys and null
Date: 2003-09-29 12:44:03
Message-ID: 200309291244.h8TCi35u027582@lurza.secnetix.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Benoff 2003-09-29 14:49:44 Computed columns and functions?
Previous Message Oliver Fromme 2003-09-29 11:40:59 Foreign keys and null