If I started with NH spatial, I supposed, that e.g. GisSharpBlog.NetTopologySuite.Geometries.Point is maped as PostgreSQL type "point", generally "NHibernate.Spatial.Type.PostGisGeometryType" is mapped as PostgreSQL type "geometry", but I`m not able to use this Postgre types with NH spatial. Maybe I do something wrong, but I debugged <http://slovnik.seznam.cz/?q=through&lang=en_cz> through NH spatial code and it seem that it maps this types simly to VARCHAR. And as I wrote there is impossible to use spatial indexes on VARCHAR. It seem to me, that NH spatial is still on the beginning (maybe only with PostgreSQL). If you use NH spatial why do you manage spatial indexes ??
From: [email protected] [mailto:[email protected]] On Behalf Of Fabio Maulo Sent: Monday, June 08, 2009 3:00 PM To: [email protected] Subject: [nhusers] Re: NHibernate spatial & PostgreSQL which is your proposal ? 2009/6/7 Malda <[email protected]> Hi, I have tried to use spatial extension with PostgreSQL (PostGIS). I have been surprised, that every spatial types (POINT, GEOMETRY) are mapped as VARCHARs to PostgreDB. It works fine, but I can`t use spatial indexes on VARCHAR columns. Do I something wrong, or nh spatial just support this kind of maping with PostgreSQL ? -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
