Hey Regina,<div><br></div><div>I was using 2.0.0 however, I had pulled the legacy.sql file down from the users' list without knowing it lived in the contrib directory of the package I'd downloaded.</div><div><br></div>
<div>That (and legacy_mininmal) has everything I needed.</div><div><br></div><div>Thanks! Sam<br><br><div class="gmail_quote">On Fri, Jul 6, 2012 at 12:59 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div style="WORD-WRAP:break-word">
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Sam,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Which version of PostGIS 2.0. I see it on my generated
legacy.sql for 2.0.1. I recall it was put in before 2.0 release as well,
but in interim versions prior to 2.0.0 release it may have still
been packaged in core file or accidentally
left out.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">My 2.0.1 legacy.sql has this:</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">-- Deprecation in 1.2.3<br>CREATE OR REPLACE FUNCTION
AsText(geometry)<br> RETURNS TEXT<br> AS
'$libdir/postgis-2.0','LWGEOM_asText'<br> LANGUAGE 'c' IMMUTABLE
STRICT; </font></span></div><div class="im">
<div dir="ltr" align="left"><span> </span></div>
<div dir="ltr" align="left"><span></span><font face="Arial"><font color="#0000ff"><font>H<span>ope
that helps,</span></font></font></font></div>
<div dir="ltr" align="left"><span></span><span></span><font face="Arial"><font color="#0000ff"><font>R<span>egina</span></font></font></font></div>
<div dir="ltr" align="left"><span></span><span></span><font face="Arial"><font color="#0000ff"><font><a href="http://www.postgis.us" target="_blank">h<span>ttp://www.postgis.us</span></a></font></font></font></div>
<div dir="ltr" align="left"><font face="Arial"><font color="#0000ff"><font><span></span></font></font></font><br> </div>
</div><blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px" dir="ltr">
<div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Samuel Smith<br><b>Sent:</b> Thursday, July 05, 2012 10:17
AM<br><b>To:</b> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><div><div class="h5"><br><b>Subject:</b>
[postgis-users] ??: ??: Postgis 2.0 and geoserver 2.1 rc4<br></div></div></font><br></div><div><div class="h5">
<div></div>
<h1 style="LINE-HEIGHT:normal;TEXT-TRANSFORM:none;FONT-VARIANT:normal;FONT-STYLE:normal;TEXT-INDENT:0px;LETTER-SPACING:normal;FONT-FAMILY:verdana,arial,helvetica;WHITE-SPACE:normal;COLOR:rgb(101,101,153);FONT-SIZE:15pt;WORD-SPACING:0px">
<span style="FONT-FAMILY:courier;white-space:pre-wrap;COLOR:rgb(0,0,0);FONT-SIZE:13px;FONT-WEIGHT:normal">Hey Regina,</span></h1>
<div><span style="font-size:13px;white-space:pre-wrap;font-family:courier;font-weight:normal"><br></span></div>
<div><span style="font-size:13px;white-space:pre-wrap;font-family:courier;font-weight:normal">Excuse what might be a silly question, but in that
legacy.sql file I can't find an (st_)AsText function, just
st_text().</span></div>
<div><span style="font-size:13px;white-space:pre-wrap;font-family:courier;font-weight:normal"><br></span></div>
<div><font face="courier"><span style="white-space:pre-wrap;FONT-SIZE:13px">---
Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_text(geometry) RETURNS text
AS '$libdir/postgis-2.0','LWGEOM_to_text' LANGUAGE 'C' IMMUTABLE STRICT;
</span></font><span style="font-size:13px;white-space:pre-wrap;font-family:courier;font-weight:normal"></span></div>
<div><span style="font-size:13px;white-space:pre-wrap;font-family:courier;font-weight:normal"><br></span></div>
<div><span style="font-size:13px;white-space:pre-wrap;font-family:courier;font-weight:normal">Restoring just the minimal set of functions needed to
resolve this issue, is that the droid we're looking for? (along with force_2d
and envelope, which I could find).</span></div>
<div><span style="font-size:13px;white-space:pre-wrap;font-family:courier;font-weight:normal"><br></span></div>
<div><span style="font-size:13px;white-space:pre-wrap;font-family:courier;font-weight:normal">Cheers, Sam</span></div>
<h1 style="LINE-HEIGHT:normal;TEXT-TRANSFORM:none;FONT-VARIANT:normal;FONT-STYLE:normal;TEXT-INDENT:0px;LETTER-SPACING:normal;FONT-FAMILY:verdana,arial,helvetica;WHITE-SPACE:normal;COLOR:rgb(101,101,153);FONT-SIZE:15pt;WORD-SPACING:0px">
<span style="FONT-FAMILY:courier;white-space:pre-wrap;COLOR:rgb(0,0,0);FONT-SIZE:13px;FONT-WEIGHT:normal">====</span></h1>
<h1 style="LINE-HEIGHT:normal;TEXT-TRANSFORM:none;FONT-VARIANT:normal;FONT-STYLE:normal;TEXT-INDENT:0px;LETTER-SPACING:normal;FONT-FAMILY:verdana,arial,helvetica;WHITE-SPACE:normal;COLOR:rgb(101,101,153);FONT-SIZE:15pt;WORD-SPACING:0px">
<span style="FONT-FAMILY:courier;white-space:pre-wrap;COLOR:rgb(0,0,0);FONT-SIZE:13px;FONT-WEIGHT:normal">I think you just need to install the AsText, force_2d,
Envelope functions from the attached file (based on what you have below). but
safe enough to install all if you want.</span></h1><pre style="text-indent:0px;letter-spacing:normal;font:10pt courier;text-transform:none;word-spacing:0px">
Hope that helps,
Regina
<a href="http://www.postgis.us/" target="_blank">http://www.postgis.us</a>
_____
From: <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis-users-bounces at postgis.refractions.net</a> [mailto:<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis-users-bounces at postgis.refractions.net</a>] On Behalf Of ??
Sent: Tuesday, April 19, 2011 9:37 AM
To: PostGIS Users Discussion
Subject: [postgis-users] ??: ??: Postgis 2.0 and geoserver 2.1 rc4
I'm sorry that the error happened again. Here is the information in the postgis log and geoserver also gave a error report.
I am not sure whether I have installed the function right. Someone told me just to ran it like SQL languags... So I did like that...
the information in the postgis log :
2011-04-19 20:58:12 HKT FATAL: the database system is starting up
2011-04-19 20:58:13 HKT LOG: database system is ready to accept connections
2011-04-19 20:58:13 HKT LOG: autovacuum launcher started
2011-04-19 21:03:41 HKT ERROR: relation "public.gt_pk_metadata" does not exist at character 15
2011-04-19 21:03:41 HKT STATEMENT: SELECT * FROM public.GT_PK_METADATA
2011-04-19 21:03:47 HKT ERROR: function envelope(box2d) does not exist at character 24
2011-04-19 21:03:47 HKT HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2011-04-19 21:03:47 HKT STATEMENT: select AsText(force_2d(Envelope(ST_Estimated_Extent('public', 'nyc_buildings', 'the_geom'))))
2011-04-19 21:03:47 HKT ERROR: function envelope(box3d_extent) does not exist at character 30
2011-04-19 21:03:47 HKT HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2011-04-19 21:03:47 HKT STATEMENT: SELECT ST_AsText(ST_Force_2D(Envelope(ST_Extent("the_geom"::geometry)))) FROM "public"."nyc_buildings"
the imformation in geoserver:
Oops, something went wrong...
Sorry, something unexpected happened on the server.
Here's an error report you can include in a JIRA bug report about this issue:
java.lang.RuntimeException: java.io.IOException: Error occured calculating bounds
at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:476)
at org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:178)
at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:369)
at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:341)
at org.geotools.data.SimpleFeatureSourceBridge.getBounds(SimpleFeatureSourceBridge.java:49)
at org.vfny.geoserver.global.GeoServerFeatureSource.getBounds(GeoServerFeatureSource.java:529)
at org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:463)
at org.geoserver.web.data.resource.BasicResourceConfig$1.onSubmit(BasicResourceConfig.java:115)
at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:68)
at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:143)
at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177)
at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:300)
at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:119)
at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92)
at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:545)
at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484)
at org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:160)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:158)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:68)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp(RememberMeProcessingFilter.java:116)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:192)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:192)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:99)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:99)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:99)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp(RememberMeProcessingFilter.java:116)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:192)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185)
at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:39)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:48)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp(RememberMeProcessingFilter.java:116)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
Caused by: java.io.IOException: Error occured calculating bounds
at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1136)
at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:469)
... 154 more
Caused by: org.postgresql.util.PSQLException: ERROR: function envelope(box3d_extent) does not exist
建议：No function matches the given name and argument types. You might need to add explicit type casts.
位置：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:1112)
... 155 more
------------------ 原始邮件 ------------------
发件人: "Paragon Corporation"<<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">lr at pcorp.us</a>>;
发送时间: 2011年4月18日(星期一) 晚上10:33
收件人: "'PostGIS Users Discussion'"<<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis-users at postgis.refractions.net</a>>;
主题: Re: [postgis-users] ??: Postgis 2.0 and geoserver 2.1 rc4
I suspect this is my fault since I cleared out most of the deprecated functions in this ticket:
<a href="http://trac.osgeo.org/postgis/ticket/737" target="_blank">http://trac.osgeo.org/postgis/ticket/737</a>
and evidentally geoserver is still using some.
I'm guessing it is the removal of st_box2d that is posing a problem but can't be sure: try installing this function to see if it solves your problem:
CREATE OR REPLACE FUNCTION st_box2d(geometry)
RETURNS box2d
AS '$libdir/postgis-2.0','LWGEOM_to_BOX2DFLOAT4'
LANGUAGE 'C' IMMUTABLE STRICT;
(Note this function in its current form may change before release).
If that doesn't fix it, it would be great if you look in your postgresql/pg_log folder at the last log file. It should show the sql error it is trying to run that is failing.
There is a legacy.sql file that also gets copied during install for people that need to run with old installs of applications that use removed functions. This I'm testing right now to get rid of the remaining install bugs in it and to add a regress test for it.
Hope that helps,
Regina
<a href="http://www.postgis.us/" target="_blank">http://www.postgis.us</a> <<a href="http://www.postgis.us/" target="_blank">http://www.postgis.us/</a>>
_____
From: <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis-users-bounces at postgis.refractions.net</a> [mailto:<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis-users-bounces at postgis.refractions.net</a>] On Behalf Of ??
Sent: Monday, April 18, 2011 8:06 AM
To: PostGIS Users Discussion
Subject: [postgis-users] ??: Postgis 2.0 and geoserver 2.1 rc4
Thanks for your kind-hearted answer. The data from the table is the same.
There is a sample data in geoserver's user documentation named nyc_buildings.sql.
When we use PostgreSQL9.0、postgis 1.5 and geoserver 2.1 rc4 to publish this data, everything goes all right.
But when we change postgis1.5 to postgis2.0, the problem comes....
There are two bouding boxes to fill. When we clicked Compute from data or Compute from Native bounds, the error happened...
Someone says that postgis API has changed in 2.0 for bounding boxes. So the error happens. Do you agree with him? And if it is true, does it mean that we can't use postgis2.0 to publish the layer or there is a need of other tools to solve it? I'm looking forword to your reply. Thank you very much.
------------------ 原始邮件 ------------------
发件人: "Maria Arias de Reyna"<<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">marias at emergya.es</a>>;
发送时间: 2011年4月18日(星期一) 下午3:18
收件人: "PostGIS Users Discussion"<<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis-users at postgis.refractions.net</a>>;
主题: Re: [postgis-users] Postgis 2.0 and geoserver 2.1 rc4
El Monday 18 April 2011, 龙龙 escribió:
><i> Hi, I am getting the following error when trying to add a layer from a
</i>><i> postgis 2.0 database: java.lang.RuntimeException: java.io.IOException:
</i>><i> Error occured calculating bounds at
</i>><i> org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.ja
</i>><i> va:476) at
</i>><i> org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java
</i>><i> :178) at
</i>><i> org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSourc
</i>><i> e.java:369) at
</i>><i> org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSourc
</i>><i> e.java:341) at
</i>><i> org.geotools.data.SimpleFeatureSourceBridge.getBounds(SimpleFeatureSourceB
</i>><i> ridge.java:49) at
</i>><i> org.vfny.geoserver.global.GeoServerFeatureSource.getBounds(GeoServerFeatur
</i>><i> eSource.java:529) at
</i>><i> org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:4
</i>><i> 63) at
</i>><i> org.geoserver.web.data.resource.BasicResourceConfig$1.onSubmit(BasicResour
</i>><i> ceConfig.java:115) at
</i>><i> org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubm
</i>><i> itLink.java:68) at
</i>><i> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitB
</i>><i> ehavior.java:143) at
</i>><i> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:17
</i>><i> 7) at
</i>><i> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefau
</i>><i> ltAjaxBehavior.java:300) at
</i>><i> org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.
</i>><i> processEvents(BehaviorRequestTarget.java:119) at
</i>><i> org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(Abst
</i>><i> ractRequestCycleProcessor.java:92) at
</i>><i> org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1
</i>><i> 250) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) at
</i>><i> org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436) at
</i>><i> org.apache.wicket.RequestCycle.request(RequestCycle.java:545) at
</i>><i> org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484)
</i>><i> at
</i>><i> org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:16
</i>><i> 0) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at
</i>><i> javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at
</i>><i> org.springframework.web.servlet.mvc.ServletWrappingController.handleReques
</i>><i> tInternal(ServletWrappingController.java:158) at
</i>><i> org.springframework.web.servlet.mvc.AbstractController.handleRequest(Abstr
</i>><i> actController.java:153) at
</i>><i> org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(
</i>><i> SimpleControllerHandlerAdapter.java:48) at
</i>><i> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherSer
</i>><i> vlet.java:875) at
</i>><i> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServ
</i>><i> let.java:809) at ....
</i>><i>
</i>><i> But this problem doesn't exist when I use postgis 1.5. So, is this a
</i>><i> postgis problem or a geoserver problem. How shall I deal with it?
</i>
The data from the table is the same?
I had this error once when the geometry column wasn't correctly defined. Are
you sure the table is defined on the geometry_columns table?
Can you look inside geoserver to see which is the exact sql sentence that is
used there?
--
María Arias de Reyna Domínguez
Área de Operaciones
Emergya Consultoría
Tfno: <a href="tel:%2B34%20954%2051%2075%2077" value="+34954517577" target="_blank">+34 954 51 75 77</a> / <a href="tel:%2B34%20607%2043%2074%2027" value="+34607437427" target="_blank">+34 607 43 74 27</a>
Fax: <a href="tel:%2B34%20954%2051%2064%2073" value="+34954516473" target="_blank">+34 954 51 64 73</a>
<a href="http://www.emergya.es" target="_blank">www.emergya.es</a>
_______________________________________________
postgis-users mailing list
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis-users at postgis.refractions.net</a>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <<a href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20110419/8726171e/attachment.html" target="_blank">http://postgis.refractions.net/pipermail/postgis-users/attachments/20110419/8726171e/attachment.html</a>>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: legacy.sql
Type: application/octet-stream
Size: 48488 bytes
Desc: not available
URL: <<a href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20110419/8726171e/attachment.obj" target="_blank">http://postgis.refractions.net/pipermail/postgis-users/attachments/20110419/8726171e/attachment.obj</a>>
</pre>
<hr style="text-indent:0px;letter-spacing:normal;font:medium Times;text-transform:none;white-space:normal;word-spacing:0px">
<div style="text-indent:0px;letter-spacing:normal;font:10pt verdana,arial,helvetica;text-transform:none;white-space:normal;word-spacing:0px"><br></div>
<ul style="text-indent:0px;letter-spacing:normal;font:medium Times;text-transform:none;white-space:normal;word-spacing:0px">
<li style="FONT-FAMILY:verdana,arial,helvetica;FONT-SIZE:10pt">Previous
message: <a href="http://postgis.refractions.net/pipermail/postgis-users/2011-April/029447.html" target="_blank">[postgis-users]
回复： ??: Postgis 2.0 and geoserver 2.1 rc4</a>
</li><li style="FONT-FAMILY:verdana,arial,helvetica;FONT-SIZE:10pt">Next
message: <a href="http://postgis.refractions.net/pipermail/postgis-users/2011-April/029449.html" target="_blank">[postgis-users]
Clip and select outside an polygon</a>
</li><li style="FONT-FAMILY:verdana,arial,helvetica;FONT-SIZE:10pt"><b style="FONT-FAMILY:verdana,arial,helvetica;COLOR:rgb(101,101,153);FONT-WEIGHT:bold">Messages
sorted by:</b> <a href="http://postgis.refractions.net/pipermail/postgis-users/2011-April/date.html#29453" target="_blank">[
date ]</a> <a href="http://postgis.refractions.net/pipermail/postgis-users/2011-April/thread.html#29453" target="_blank">[
thread ]</a> <a href="http://postgis.refractions.net/pipermail/postgis-users/2011-April/subject.html#29453" target="_blank">[
subject ]</a> <a href="http://postgis.refractions.net/pipermail/postgis-users/2011-April/author.html#29453" target="_blank">[
author ]</a></li></ul>
<div><br></div></div></div></blockquote></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>