| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | mike <mike(at)bristolreccc(dot)co(dot)uk> |
| Cc: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: FK issue |
| Date: | 2004-06-10 16:47:32 |
| Message-ID: | 20040610094505.J20240@megazone.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 10 Jun 2004, mike wrote:
> On Thu, 2004-06-10 at 17:03, Uwe C. Schroeder wrote:
> > Try to add a null value to lk_sub_con.type - or any value that's not in
> > lk_sort_of_contact. Postgres will throw an error.
>
> this is the problem - it doesnt if I put a null in (the refernced column
> has no nulls)
NULLs in a referencing column are a special case in the spec. For a
single column key, a NULL is considered to pass the constraint. For
multiple column keys it depends on the match type.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Uwe C. Schroeder | 2004-06-10 16:50:26 | Re: FK issue |
| Previous Message | Mr sidh bhatt | 2004-06-10 16:45:12 | Returning rowsets/results from a function to another one in plpgsl. |