[postgis-users] ERROR: Geometry has Z dimension but column does not

Paul Ramsey pramsey at opengeo.org
Thu Apr 5 11:17:40 PDT 2012


Working here. It's a problem with the st_geographyFromText somehow,
you can insert values into the table if you feed it text directly.

INSERT INTO myTable (location) VALUES ('SRID=4326;PointZ(85 35 500)');

P

On Thu, Apr 5, 2012 at 11:16 AM, Paul Ramsey <pramsey at opengeo.org> wrote:
> On Thu, Apr 5, 2012 at 11:15 AM, Sandro Santilli <strk at keybit.net> wrote:
>> On Thu, Apr 05, 2012 at 01:53:59PM -0400, Gold, Jack L  (US SSA) wrote:
>>> My apologies, I sent the previous post in a hurry.  Below is the query I am using to insert a geography from text.  I still receive the error indicated.  I am, in fact, looking to insert a geography with a Z value.
>>>
>>> CREATE TABLE myTable(location geography(PointZ,4326));
>>>
>>> INSERT INTO myTable (location) VALUES (st_geographyFromText('SRID=4326;PointZ(85 35 500)'));
>>>
>>> ERROR:  Geometry has Z dimension but column does not
>>
>> Works for me. What's the result of : SELECT Postgis_full_version() ?
>
> It does? Doesn't for me! working this now.
> P
>
>> --strk;
>>
>>  ,------o-.
>>  |   __/  |    Delivering high quality PostGIS 2.0 !
>>  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
>>  `-o------'
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list