assign_vertex_id fails srid constraint

[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.

[anton]

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.