Ni Nathan,

I imagine all the non "st" functions have been totally removed in postgis
2.0, while in postgis 1.x i believe they were only deprecated. Someone will
have to comb through the postgis datastore/dialect and remove them. Possibly
checking version to maintain backwards compatibility. Should not be too
difficult a task.

Can you file a geotools jira for this issue? Thanks.

-Justin

On Mon, Jan 24, 2011 at 10:29 AM, Nathan Clay <[email protected]>wrote:

> Hi,
>
> I am getting the following error when trying to add a layer from a postgis
> 2.0 database:
>
> Caused by: org.postgresql.util.PSQLException: ERROR: function
> envelope(box3d_extent) does not exist
>   Hint: No function matches the given name and argument types. You might
> need to add explicit type casts.
>   Position: 30
>     at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
>     at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
>     at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>     at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
>     at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
>     at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
>     at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
>     at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
>     at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1101)
>
> So, is this a postgis problem or a geoserver problem. My question is.
> Should I be talking with you or the postgis mailing list?
>
>
> Thanks,
>
> Nathaniel H Clay
>
>
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better
> price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to