From: | Chris <dmagick(at)gmail(dot)com> |
---|---|
To: | Adam <adam(at)spatialsystems(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What's wrong with this SQL? |
Date: | 2006-05-10 04:20:12 |
Message-ID: | 446169FC.6090407@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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,
> "password" character varying(16) NOT NULL, "email" character
> varying(100) NOT NULL, "privilege" integer(2) NOT NULL, PRIMARY KEY
> ("user_ID"))
"privilege" integer(2) NOT NULL
Postgres doesn't support integers of different sizes like this.
http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-INT
--
Postgresql & php tutorials
http://www.designmagick.com/
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2006-05-10 04:29:07 | Re: What's wrong with this SQL? |
Previous Message | Tom Lane | 2006-05-10 04:19:07 | Re: What's wrong with this SQL? |