[postgis-users] Trouble after upgrade to 1.4.0

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Peter N.
Schweitzer
Sent: Tuesday, December 08, 2009 11:02 PM
To: postgis-users at lists.refractions.net
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: pschweitzer at usgs.gov
<http://geology.usgs.gov/peter/>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users