Re: BUG #2771: NULL values in FOREIGN KEY fields - Mailing list pgsql-bugs

From Euler Taveira de Oliveira
Subject Re: BUG #2771: NULL values in FOREIGN KEY fields
Date
Msg-id 20061121022846.GC32538@timbira.com
Whole thread Raw
In response to BUG #2771: NULL values in FOREIGN KEY fields  ("vincent" <vincent@iim.nctu.edu.tw>)
List pgsql-bugs
vincent wrote:

> When insert a null value in foreign key fields, an error occurs.
>
This is not a bug. The error occurs because you're trying to insert NULL
in a NOT NULL field (C_Group_Parent). Try to strip the NOT NULL from
C_Group_Parent field so you can insert NULL in it.


--
  Euler Taveira de Oliveira
  http://www.timbira.com/

pgsql-bugs by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: BUG #2771: NULL values in FOREIGN KEY fields
Next
From: "Jaime Casanova"
Date:
Subject: Re: BUG #2764: Capital letter in tables or columns not supported