Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA52627 for ; Sun, 27 Feb 2000 23:29:36 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id XAA20616; Sun, 27 Feb 2000 23:29:19 -0500 (EST) To: "Seth Banks" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Problems with create table continued... In-reply-to: References: Comments: In-reply-to "Seth Banks" message dated "Sun, 27 Feb 2000 19:35:13 -0800" Date: Sun, 27 Feb 2000 23:29:19 -0500 Message-ID: <20613.951712159@sss.pgh.pa.us> From: Tom Lane "Seth Banks" writes: > Anyone see a problem with this code?! > CREATE TABLE content ( > content_id serial, > parent_id int4 NOT NULL, > parent_type int4 NOT NULL, > author_id int4 NOT NULL, > title text NOT NULL, > url text NULL, > start_date date NOT NULL, > end_date date NOT NULL, > priority int4 NULL, > content text NULL, > source text NOT NULL > ); > ERROR: parser: parse error at or near "null" NULL is not a valid column constraint according to SQL92. (Even if it were valid, it'd be redundant.) Drop that on those three columns and you'll be fine. regards, tom lane