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@sferacarta.com