Yes, geometry_columns table is readable for user connecting to the db. This turned out to be a mismatch between the view name and entry in geometry_columns table. This issue made me discover that f_table_name column in geometry_columns table is case-sensitive.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andrea Aime Sent: February 2, 2011 02:25 PM To: Nji, Klaus Cc: [email protected] Subject: Re: [Geoserver-users] Geometry Type not being read corectly from PostGIS database On Wed, Feb 2, 2011 at 7:23 PM, Nji, Klaus <[email protected]> wrote: > Quick question folks: > > > > Would cause GeoServer RC1 to display type of "Geometry" for property > "the_geom" in the Feature Type Details section of a layer definition, if the > entry for this feature in the Postgres table geometry_columns indicates that > it is a POLYGON? That sounds odd. Is the geometry_columns table readable for the user that connects to the db? Maybe it's a schema issue? Cheers Andrea -- Ing. Andrea Aime Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584962313 fax: +39 0584962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ----------------------------------------------------- ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
