Thank you, that is the problem. That column should not have been created as an ARRAY type.
Lance
From: David Johnston [via PostgreSQL] [mailto:ml-node+[hidden email]] Sent: Friday, October 19, 2012 4:36 PM To: Lance Magnell Subject: Re: Insert strings that contain colons into a table
> -----Original Message----- > From: [hidden email] [mailto:pgsql-sql- > [hidden email]] On Behalf Of lmagnell > Sent: Friday, October 19, 2012 4:25 PM > To: [hidden email] > Subject: [SQL] Insert strings that contain colons into a table > > How can I insert multiple strings into a table where the strings contain colons. > This case fails: > > INSERT INTO wwn (wwn_start,wwn_end) VALUES > ('50:06:0B:00:00:C2:86:80','50:06:0B:00:00:C2:86:83'); > ERROR: array value must start with "{" or dimension information at character > 71 LINE 1: ..._start,wwn_end) VALUES ('50:06:0B:00:00:C2:86:80','50:06:0B:... > > But this case passes: > > INSERT INTO wwn (wwn_start) VALUES ('50:06:0B:00:00:C2:86:80'); > > Thank you, > Lance >
The "colon" has nothing to do with it.
It appears that "wwn_end" is defined as an array and not a simple text value.
You need to provide the table definition for "wwn".
This is a section in the documentation regarding arrays but I am guessing the use of an array in this situation is a mistake.
