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