Re: [SQL] Problems with create table continued...

"Seth Banks" <seth(at)subimage(dot)com> 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