Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group