Link to home
Start Free TrialLog in
Avatar of waipahu
waipahu

asked on

ERROR: array value must start with "{" or dimension information

I am trying to INSERT a record in my postgres table and I get t his error:
ERROR:  array value must start with "{" or dimension information

My table definnition
CREATE TABLE paymentmethod
(
  code varchar(1) NOT NULL,
  description varchar(30)[] NOT NULL
)
WITH OIDS;
ALTER TABLE paymentmethod OWNER TO postgres;
GRANT ALL ON TABLE paymentmethod TO postgres;
COMMENT ON TABLE paymentmethod IS 'Payment Method Table';

My Insert SQL:

insert into paymentmethod
values('A','ACH');

Do you know what might be causing the problem?
ASKER CERTIFIED SOLUTION
Avatar of ravenpl
ravenpl
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of earth man2
earth man2
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial