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,
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
(DBA: DataBase Aniquilator ;)
In response to
pgsql-novice by date
|Next:||From: tövis||Date: 2005-05-23 21:32:14|
|Subject: "NOT NULL"|
|Previous:||From: tövis||Date: 2005-05-23 21:09:14|
|Subject: "NOT NULL" field|