NOT NULL doesn't work in v7 - Mailing list pgsql-hackers

From Jose Soares
Subject NOT NULL doesn't work in v7
Date
Msg-id 38BA93FC.10029435@sferacarta.com
Whole thread Raw
Responses Re: [HACKERS] NOT NULL doesn't work in v7
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: bug in 7.0
Next
From: Oleg Broytmann
Date:
Subject: Re: [HACKERS] Locale support broken in latest snapshots