I'm trying to create a table and I'm getting this error:
SQL error:
ERROR: syntax error at or near ( at character 39
In statement:
CREATE TABLE users (user_ID SERIAL(12), first_name character
varying(40) NOT NULL, last_name character varying(40) NOT NULL, password
character
PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Adam
Sent: Tuesday, May 09, 2006 9:06 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] What's wrong with this SQL?
I'm trying to create a table and I'm getting this error:
SQL error:
ERROR: syntax error
Adam [EMAIL PROTECTED] writes:
I'm trying to create a table and I'm getting this error:
ERROR: syntax error at or near ( at character 39
In statement:
CREATE TABLE users (user_ID SERIAL(12),
SERIAL doesn't take a parameter.
regards, tom lane
Adam wrote:
I'm trying to create a table and I'm getting this error:
SQL error:
ERROR: syntax error at or near ( at character 39
In statement:
CREATE TABLE users (user_ID SERIAL(12), first_name character
varying(40) NOT NULL, last_name character varying(40) NOT NULL,
On May 10, 2006, at 12:06 AM, Adam wrote:
CREATE TABLE users (user_ID SERIAL(12), first_name character
varying(40) NOT NULL, last_name character varying(40) NOT NULL,
password character varying(16) NOT NULL, email character varying
(100) NOT NULL, privilege integer(2) NOT NULL, PRIMARY KEY
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)
);