Re: Foreign keys and null

Поиск
Список
Период
Сортировка
Искать
От
Oliver Fromme
Тема
Re: Foreign keys and null
Дата
Msg-id
200309291244.h8TCi35u027582@lurza.secnetix.de
Ответ на
Foreign keys and null (Oliver Fromme)
Список
Дерево обсуждения
Foreign keys and null Oliver Fromme <olli@lurza.secnetix.de>
Re: Foreign keys and null Oliver Fromme <olli@lurza.secnetix.de>
Re: Foreign keys and null Tom Lane <tgl@sss.pgh.pa.us>

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 по дате отправления
От: Oliver Fromme
Дата:
Сообщение: Foreign keys and null
От: David Benoff
Дата:
FAQ