[postgis-users] Trouble after upgrade to 1.4.0
Peter N. Schweitzer
pschweitzer at usgs.gov
Tue Dec 8 20:01:43 PST 2009
I just upgraded from 8.3.7/1.3.5 to 8.4.1/1.4.0
I now get an error when running the following query:
select ST_Box2d(ST_Transform(ST_SetSRID(ST_Extent(the_geom),4267),3395)) from ingeol_poly
ERROR: function st_setsrid(box3d_extent, integer) does not exist
LINE 1: select ST_Box2d(ST_Transform(ST_SetSRID(ST_Extent(the_geom),...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
But I can do a number of ST_ functions, and mapserver seems to work
with postgis/postgresql.
So I assume I'm using the wrong combination of magic words to get the
information I want from the database.
What I'm trying to do is get the extent, in mercator, of all of the polygons
in a layer "ingeol_poly" whose native coordinate system is geographic NAD27.
Corrections of my misunderstanding would be very helpful!
Here's the postgis_full_version():
sgmc=# select postgis_full_version();
POSTGIS="1.4.0" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September 2009" USE_STATS
Peter
--
Peter N. Schweitzer (MS 954, U.S. Geological Survey, Reston, VA 20192)
(703) 648-6533 FAX: (703) 648-6252 email: pschweitzer at usgs.gov
<http://geology.usgs.gov/peter/>
More information about the postgis-users
mailing list