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
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,
"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
e-
> From: [EMAIL 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 gettin
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"