Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Use spatial types on PostgreSQL

Description

.NET spatial types are mapped as VARCHAR on PostgreSQL. Just spatial PostgreSQL types as point, geometry etc., can be used in spatial index, it means actual version can`t use spatial indexes on PostgreSQL.

Environment

None

Activity

Show:

Ricardo Stuven June 9, 2009 at 7:06 AM

It is not mapped as GEOMETRY because a limitation of Npgsql, which could have a performance implication, but we're assuming GEOMETRY datatype and spatial indexes are being used in the database. If you use SchemaExport in combination with SpatialAuxiliaryDatabaseObject to generate the schema, PostGIS' AddGeometryColumn function is called to do the job (see http://nhforge.org/wikis/spatial/configuration-and-mapping.aspx),

External Issue

Details

Assignee

Reporter

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?

Created June 9, 2009 at 1:38 AM
Updated June 9, 2009 at 7:06 AM
Resolved June 9, 2009 at 7:06 AM
Who's Looking?