Re: Quick question re foreign keys. - Mailing list pgsql-sql

From D'Arcy J.M. Cain
Subject Re: Quick question re foreign keys.
Date
Msg-id 20071024012705.5f253946.darcy@druid.net
Whole thread Raw
In response to Re: Quick question re foreign keys.  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Responses Re: Quick question re foreign keys.
List pgsql-sql
On Wed, 24 Oct 2007 11:00:47 +0800
Paul Lambert <paul.lambert@autoledgers.com.au> wrote:
> It's marked not null as a result of being part of the primary key for 
> that table which I can't really get around.
> 
> I can get away with not having the foreign key though, so I'll have to 
> go down that path.

It can't be the primary key and have NULLs.  It sounds to me like you
have a design problem somewhere.

-- 
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-sql by date:

Previous
From: Paul Lambert
Date:
Subject: Re: Quick question re foreign keys.
Next
From: "Chuck D."
Date:
Subject: Re: request for help with COPY syntax