Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Quick question re foreign keys.
- From: "D'Arcy J.M. Cain" <darcy(at)druid(dot)net>
- To: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
- Subject: Re: Quick question re foreign keys.
- Date: Wed, 24 Oct 2007 01:27:05 -0400
On Wed, 24 Oct 2007 11:00:47 +0800 Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)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(at)druid(dot)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.
- Follow-Ups:
- Re: Quick question re foreign keys.
- From: Nis Jørgensen
- Re: Quick question re foreign keys.
- References:
- Quick question re foreign keys.
- From: Paul Lambert
- Re: Quick question re foreign keys.
- From: Tom Lane
- Re: Quick question re foreign keys.
- From: Paul Lambert
- Quick question re foreign keys.
- Prev by Date: Re: Quick question re foreign keys.
- Next by Date: Re: request for help with COPY syntax
- Previous by thread: Re: Quick question re foreign keys.
- Next by thread: Re: Quick question re foreign keys.
- Indexes: