pgRouting

Ticket #11 (closed bug report: fixed)

Opened 1 year ago

Last modified 1 year ago

assign_vertex_id fails srid constraint

Reported by: kyngchaos Assigned to:
Priority: major Milestone:
Component: pgRouting package Version: 1.0.0a
Keywords: Cc:

Description

The geometry column in the vertices_tmp table is created with no srid specified, so the srid constraint defaults to -1. When assigning vertex ids to a postgis layer with an srid, point_to_id() fails when adding a new row to vertices_tmp.

The srid of the postgis table should be looked up in "geometry_columns" and used to add the geometry column to vertices_tmp.

Change History

(in reply to: ↑ description ) 05/30/07 08:53:52 changed by anton

  • status changed from new to closed.
  • resolution set to fixed.

Replying to kyngchaos:

The geometry column in the vertices_tmp table is created with no srid specified, so the srid constraint defaults to -1. When assigning vertex ids to a postgis layer with an srid, point_to_id() fails when adding a new row to vertices_tmp. The srid of the postgis table should be looked up in "geometry_columns" and used to add the geometry column to vertices_tmp.

Please download the latest version of routing_postgis.sql from SVN, it contains fixed assign_vertex_id function.

Or you can wait a little bit - we are planning to release pgRouting 1.0.0b soon with some bugfixes.