Re: What's wrong about this sql statement?

Corn wrote:

There is a comma missing. The Statement must be

CREATE TABLE usersright (
userid INTEGER NOT NULL,
rightid INTEGER NOT NULL,
allow BOOLEAN NOT NULL DEFAULT FALSE,
^^^^^^^
CONSTRAINT pk_usersright PRIMARY KEY (userid, rightid)
);

Tableconstraints mus be seperated by comma from coulmn definiftion.

Arne.

>
> I am newbie. Try to create a table like this.
>
> CREATE TABLE usersright (
> userid INTEGER NOT NULL,
> rightid INTEGER NOT NULL,
> allow BOOLEAN NOT NULL DEFAULT FALSE
> CONSTRAINT pk_usersright PRIMARY KEY (userid, rightid)
> );
>
> But I got the following error message:
>
> ERROR: parser: parse error at or near "("
>
> I am following the syntax of SQL statement reference from postgresql web
> site.
>
> please help.
>
> thx.
>
> corn