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

[Gold, Jack L (US SSA)]

I'm beginning to think the problem is actually a corrupted database.  I don't even have a geometry_columns table anymore.  The SELECT Postgis_full_version() results in postgis_libjson_version() error shown below.  I'm going to call it a corrupted database and rebuild from scratch.  Thanks for the help Sandro.


ERROR:  function postgis_libjson_version() does not exist
LINE 1: SELECT postgis_libjson_version()
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT postgis_libjson_version()
CONTEXT:  PL/pgSQL function "postgis_full_version" line 20 at SQL statement

********** Error **********

ERROR: function postgis_libjson_version() does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Context: PL/pgSQL function "postgis_full_version" line 20 at SQL statement

--Jack

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Sandro Santilli
Sent: Thursday, April 05, 2012 2:15 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ERROR: Geometry has Z dimension but column does not

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() ?

--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