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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users