From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8749: Error Size Integer |
Date: | 2014-01-08 20:30:17 |
Message-ID: | 1389213017029-5785916.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
leandroeiro wrote
> The following bug has been logged on the website:
>
> Bug reference: 8749
> Logged by: Leandro
> Email address:
> leandroeiro@
> PostgreSQL version: 9.1.0
> Operating system: Ubuntu
> Description:
>
> I tried to change the Integer size and appears this:
>
>
> ERROR: syntax error at or near "("
> LINE 1: ...jgovce_jevents_vevent" ALTER COLUMN "ev_id" TYPE integer(12)
> ^
>
>
> No bloco:
> ALTER TABLE "public"."jgovce_jevents_vevent" ALTER COLUMN "ev_id" TYPE
> integer(12)
You cannot "change the Interger size" using "(n)" notation.
From the documentation:
http://www.postgresql.org/docs/current/static/datatype-numeric.html#DATATYPE-INT
"SQL only specifies the integer types integer (or int), smallint, and
bigint. The type names int2, int4, and int8 are extensions, which are also
used by some other SQL database systems."
So not only is your syntax wrong but you are trying to create a size that
does not exist - i.e., 12
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-8749-Error-Size-Integer-tp5785906p5785916.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-01-08 20:53:34 | Pausing at recovery target is off by one |
Previous Message | drx | 2014-01-08 19:43:12 | BUG #8750: 'simple' parser in to_tsvector() splits words on underscores |