Peter, No,but it looks like you are just being bitten by the missing autocast in the upgrade script which I think we have fixed in 1.4.1
See my comment here http://trac.osgeo.org/postgis/ticket/223 So short answer -- your problems should be solved if you run the below CREATE CAST (box3d_extent AS box3d) WITH FUNCTION st_box3d_extent(box3d_extent) AS IMPLICIT; There is another problem I ran into I describe which hopefully I'm the only one in the world affected by this other change. Thanks, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter N. Schweitzer Sent: Tuesday, December 08, 2009 11:02 PM To: [email protected] Subject: [postgis-users] Trouble after upgrade to 1.4.0 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: [email protected] <http://geology.usgs.gov/peter/> _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
