Re: BUG #2771: NULL values in FOREIGN KEY fields

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: vincent <vincent(at)iim(dot)nctu(dot)edu(dot)tw>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2771: NULL values in FOREIGN KEY fields
Date: 2006-11-21 02:28:46
Message-ID: 20061121022846.GC32538@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Reece Hart 2006-11-21 03:47:33 Re: BUG #2764: Capital letter in tables or columns not
Previous Message Jaime Casanova 2006-11-21 02:03:15 Re: BUG #2771: NULL values in FOREIGN KEY fields