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

Re: "NOT NULL" field

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: tövis <tovises(at)freemail(dot)hu>
Cc: pgsql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: "NOT NULL" field
Date: 2005-05-23 21:16:40
Message-ID: c2d9e70e0505231416fbdafcc@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 5/23/05, tövis <tovises(at)freemail(dot)hu> wrote:
>  
> Hi everybody! 
> I'm using PostgreSQL 7.4.7 on Debian Testing (Kernel 2.4.27 SMP) with winXP
> application (Clarion 6.1 RAD) through ODBC Unicode 3.0(?) Beta. 
> Currently I'm converting my existing database and realize that "NOT NULL"
> seem to be is not enough! - server accepting NULL value? 
> This is the fragment of the definition. What is wrong? 
>   
> CREATE TABLE nod
> (
>  aid     serial CONSTRAINT nod_key PRIMARY KEY NOT NULL,
>  num     INTEGER NOT NULL, 
> .... 
> ); 
>   
> Tovis 
>   
Verify you aren't saving blank spaces, that is not the same that not
null. Until, when i have constrained a field to be not null it
rejected to save nulls.

a little test, do a copy from table to file, and see the contents if
you have \N characters you are right these are nulls if not they are
not.

-- 
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

Responses

pgsql-novice by date

Next:From: tövisDate: 2005-05-23 21:32:14
Subject: "NOT NULL"
Previous:From: tövisDate: 2005-05-23 21:09:14
Subject: "NOT NULL" field

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