What's wrong about this sql statement?

From: "Corn" <corn(at)tryit(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What's wrong about this sql statement?
Date: 2001-08-31 07:58:45
Message-ID: 9mnfs9$22bh$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arne Weiner 2001-08-31 11:46:42 Re: What's wrong about this sql statement?
Previous Message Graham White 2001-08-31 05:22:17 Mysql to postgres tools -reviews?