"NOT NULL" field - Mailing list pgsql-novice

From tövis
Subject "NOT NULL" field
Date
Msg-id 001401c55fdb$ac72fa20$3401a8c0@mainxp
Whole thread Raw
Responses Re: "NOT NULL" field  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-novice
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
 

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: postgres files in windows xp
Next
From: Jaime Casanova
Date:
Subject: Re: "NOT NULL" field