Обсуждение: NOT NULL doesn't work in v7

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

Jose Soares <jose@sferacarta.com> writes:
> Seems there is a problem with parser on NOT NULL...

Yeah, known problem, will be fixed (somehow ;-)).
        regards, tom lane