Thread

NOT NULL doesn't work in v7

Jose Soares <jose@sferacarta.com> — 2000-02-28T15:27:56Z

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