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