X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 54889475A5C
	for <pgsql-sql@postgresql.org>; Mon, 10 Feb 2003 22:55:46 -0500 (EST)
Received: from mta201-rme.xtra.co.nz (mta201-rme.xtra.co.nz [210.86.15.144])
	by postgresql.org (Postfix) with ESMTP id D1AE8475A4B
	for <pgsql-sql@postgresql.org>; Mon, 10 Feb 2003 22:55:44 -0500 (EST)
Received: from mta1-rme.xtra.co.nz ([210.86.15.143])
	by mta201-rme.xtra.co.nz with ESMTP
	id <20030211035548.LYMU1191.mta201-rme.xtra.co.nz@mta1-rme.xtra.co.nz>
	for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 16:55:48 +1300
Received: from singlarc01 ([210.54.102.52]) by mta1-rme.xtra.co.nz with SMTP
	id <20030211035546.ZCVI15912.mta1-rme.xtra.co.nz@singlarc01>
	for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 16:55:46 +1300
Message-ID: <000801c2d181$6c0be360$020000c0@singlarc01>
From: "Arunachalam Jaisankar" <jsankar@xtra.co.nz>
To: <pgsql-sql@postgresql.org>
Subject: null foreign key column
Date: Tue, 11 Feb 2003 16:55:28 +1300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C2D1EE.61998D70"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/254
X-Sequence-Number: 11652

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C2D1EE.61998D70
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,

I would like to have a foreign key column in my table which allows null val=
ue also.
But the below create table sql command doesn't accept null value for person=
_id.
How to do in postgres?

create table event
(
    event_id               serial                not null,
    event_description      char(255)                     ,
    person_id              serial                        ,
    primary key (event_id),
    foreign key  (person_id)
       references person (person_id)
);

regards
Jai
------=_NextPart_000_0005_01C2D1EE.61998D70
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I would like to have a foreign key column =
in my=20
table which allows null value also.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But the below create table sql command doe=
sn't=20
accept null value for person_id.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>How to do in postgres?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial size=3D2></FONT>=
&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>create table event<BR>(<BR>&nbsp;&nbsp;&nb=
sp;=20
event_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;=20
serial&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;=20
not null,<BR>&nbsp;&nbsp;&nbsp; event_description&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;=20
char(255)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
,<BR>&nbsp;&nbsp;&nbsp;=20
person_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;=20
serial&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
,<BR>&nbsp;&nbsp;&nbsp; primary key (event_id),<BR>&nbsp;&nbsp;&nbsp; forei=
gn=20
key&nbsp; (person_id)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; references pe=
rson=20
(person_id)<BR>);</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jai</FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01C2D1EE.61998D70--