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



Mon, 28 Feb 2000 16:27:56 +0100
Jose Soares <jose@sferacarta.com>
NOT NULL doesn't work in v7
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

Mon, 28 Feb 2000 11:12:43 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] NOT NULL doesn't work in v7 