Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Quick question re foreign keys.
- From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
- Subject: Re: Quick question re foreign keys.
- Date: Wed, 24 Oct 2007 11:00:47 +0800
Tom Lane wrote:
If I'm understanding you correctly, the problem is not the foreign key, it's that you marked the column NOT NULL. A foreign key constraint by itself will allow a NULL in the referencing column to pass. You choose whether you want to allow that or not by separately applying a NOT NULL constraint or not. regards, tom lane
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.
Cheers, P. -- Paul Lambert Database Administrator AutoLedgers
- Follow-Ups:
- Re: Quick question re foreign keys.
- From: Paul Lambert
- Re: Quick question re foreign keys.
- From: D'Arcy J.M. Cain
- Re: Quick question re foreign keys.
- References:
- Quick question re foreign keys.
- From: Paul Lambert
- Re: Quick question re foreign keys.
- From: Tom Lane
- Quick question re foreign keys.
- Prev by Date: Re: request for help with COPY syntax
- Next by Date: Re: Quick question re foreign keys.
- Previous by thread: Re: Quick question re foreign keys.
- Next by thread: Re: Quick question re foreign keys.
- Indexes: