[postgis-users] ERROR: array value must start with "{" or dimensioninformation

Paragon Corporation lr at pcorp.us
Tue Feb 10 20:01:22 PST 2009


The below you have works okay on our 8.2 and 8.3 installs.

Normally I output the fields I am inserting into and also am explicit about
the casting behavior.  You are allowing the system to cast 
To a geometry and its possible you have some default cast defined in your
system that is casting to another type.

Try doing
INSERT INTO points(pt,name) 
	VALUES(ST_GeomFromText('POINT(0 0)'), 'Origin');


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ben
Sent: Tuesday, February 10, 2009 10:06 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] ERROR: array value must start with "{" or

I am trying to test my postgres/postgis install and I am running into a
problem with a simple point table.
I am using PostgreSQL 8.3.5 on Ubuntu 8.1 I created this table:
create table points (pt geometry, name varchar);

Then I try this insert statement:
insert into points values ('POINT(0 0)', 'Origin');

I get the following error and I don't know why. I have never seen it when
trying this in the past:
ERROR:  array value must start with "{" or dimension information

Any thoughts would be greatly appreciated.
postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list