[postgis-users] ERROR: Geometry has Z dimension but column does not
Paul Ramsey
pramsey at opengeo.org
Thu Apr 5 11:16:05 PDT 2012
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