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

Salvatore Larosa lrssvtml at gmail.com
Thu Apr 5 11:23:00 PDT 2012


Il giorno gio, 05/04/2012 alle 11.16 -0700, Paul Ramsey ha scritto:
> 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
> 

Same problem here.
I get: ERROR:  Geometry has Z dimension but column does not

-SL





More information about the postgis-users mailing list