| From: | "D'Arcy J(dot)M(dot) 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: | 2007-10-24 05:27:05 |
| Message-ID: | 20071024012705.5f253946.darcy@druid.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chuck D. | 2007-10-24 06:59:04 | Re: request for help with COPY syntax |
| Previous Message | Paul Lambert | 2007-10-24 03:09:27 | Re: Quick question re foreign keys. |