"NOT NULL" field

From: tövis <tovises(at)freemail(dot)hu>
To: "pgsql novice" <pgsql-novice(at)postgresql(dot)org>
Subject: "NOT NULL" field
Date: 2005-05-23 21:09:14
Message-ID: 001401c55fdb$ac72fa20$3401a8c0@mainxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jaime Casanova 2005-05-23 21:16:40 Re: "NOT NULL" field
Previous Message operationsengineer1 2005-05-23 18:19:29 Re: postgres files in windows xp