[postgis-users] Re: ERROR: array value must start with "{" or dimension information

Ben Tuttle funktacular at gmail.com
Tue Feb 10 20:09:29 PST 2009


Apologies, it appears there was a typo here and we had a table with a
character array instead of a varchar. So the error was due to passing
in a string instead of an array.

On Tue, Feb 10, 2009 at 8:06 PM, Ben Tuttle <funktacular at gmail.com> wrote:
> 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.
> --
> Cheers,
> Ben
>



-- 
Cheers,
Ben Tuttle



More information about the postgis-users mailing list