What's wrong with this SQL?

From: "Adam" <adam(at)spatialsystems(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What's wrong with this SQL?
Date: 2006-05-10 04:06:07
Message-ID: 002c01c673e7$10ea7bc0$0200a8c0@PANASONIULSWMR
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 varying(16) NOT NULL, "email" character varying(100) NOT NULL,
"privilege" integer(2) NOT NULL, PRIMARY KEY ("user_ID"))

What's wrong with this SQL?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2006-05-10 04:18:11 Re: What's wrong with this SQL?
Previous Message Scott Lamb 2006-05-10 03:37:14 Re: [PERFORM] Arguments Pro/Contra Software Raid