On Thu, Nov 21, 2013 at 10:06 AM, Eugenio Trumpy <[email protected]>wrote:
> Hi again,
>
> here the log output relate to the query:
> 2013-11-21 10:01:07,906 DEBUG [org.geotools.jdbc] - SELECT count(*) AS
> gt_result_ FROM (SELECT * FROM "public"."pozzi_decodificati_vigor" WHERE
> ("the_geom" && ST_GeomFromText('POLYGON ((18.71948828125 40.28446472745902,
> 19.074246093750002 40.28446472745902, 19.074246093750002 39.92970692827869,
> 18.71948828125 39.92970692827869, 18.71948828125 40.28446472745902))', 0)
> AND ST_Intersects("the_geom", ST_GeomFromText('POLYGON ((18.71948828125
> 40.28446472745902, 19.074246093750002 40.28446472745902, 19.074246093750002
> 39.92970692827869, 18.71948828125 39.92970692827869, 18.71948828125
> 40.28446472745902))', 0)) AND ('ALL_LABEL_CLASSES_ENABLED' =
> 'ALL_LABEL_CLASSES_ENABLED' AND 1 = 1)) LIMIT 50) gt_limited_
>
Ok, so this GeoServer still thinks the srid is 0.
The srid is read the first time GeoServer tries to access that view
(normally, during startup when checking if the feature type can be computed)
and from there on, it won't consult the geometry_columns anymore.
Well, unless you force it to, by using the "reset" button in the status
page, or by restarting GeoServer fully
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
