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

[Sandro Santilli]

On Thu, Apr 05, 2012 at 09:34:32AM -0400, Gold, Jack L  (US SSA) wrote:
> Recently updated to beta5 and now I'm having problems with selections on a geography column when I do ST_geographyFromText('0 0 0', 4326).  I get: ERROR: Geometry has Z dimension but column does not.  The column is defined as a geography (PointZ, 4326).  Is this now incorrect?

Jack,
'0 0 0' is not a valid geography representation,
and there's no ST_GeographyFromText taking a SRID
argument.

Please provide the exact query you're using, and
exact error message.

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'