Seems there is a problem with parser on NOT NULL...
CREATE TABLE distributors4 (
did DECIMAL(3) CONSTRAINT no_nullo NOT NULL,
name VARCHAR(40) NOT NULL
);
$ psql hygea1 -f not_null.ref
psql:not_null.ref:6: ERROR: parser: parse error at or near "not"
CREATE TABLE actors (
did DECIMAL(03) PRIMARY KEY not null,
name VARCHAR(40)
);
verde:~/ref/tmp$ psql hygea1 -f primary_key.ref
psql:primary_key.ref:4: ERROR: parser: parse error at or near "not"
--
Jose' Soares
Bologna, Italy Jose(at)sferacarta(dot)com