Re: What's wrong with this SQL?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:19:07
Message-ID: 26088.1147234747@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Adam" <adam(at)spatialsystems(dot)org> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-05-10 04:20:12 Re: What's wrong with this SQL?
Previous Message Dann Corbit 2006-05-10 04:18:11 Re: What's wrong with this SQL?