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