Re: ERROR: array_in: Need to specify dimension

remove the '[]' characters, if all you want is a variable length string column, they are unneeded.

That's 'C/++' syntax in that usage!

Charles Lewis wrote:
> New to postgres and trying to create a simple table with a text
> (variable length) column and getting the following error:
>
> An error occured in pgAdminII:frmSQLOutput.cmdSave_Click:
>
> Number: -2147467259
> Description: ERROR: array_in: Need to specify dimension
>
> Here's the schema:
>
> -- Table: public.client
> CREATE TABLE public.client (
>  clientid int4 NOT NULL,
>  name varchar(50),
>  comment text[],
>  CONSTRAINT client_pkey PRIMARY KEY (clientid)
> ) WITH OIDS;
>
> Any suggestions?
>
> Charles Lewis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>