NOT NULL doesn't work in v7

From: Jose Soares <jose(at)sferacarta(dot)com>
To: hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: NOT NULL doesn't work in v7
Date: 2000-02-28 15:27:56
Message-ID: 38BA93FC.10029435@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sferacarta(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 2000-02-28 15:38:48 Re: [HACKERS] Re: ALTER TABLE DROP COLUMN
Previous Message Thomas Lockhart 2000-02-28 15:26:48 Re: [HACKERS] 'now' in 7.0