[pgrouting-users] assign_vertex_id error

[Dave Potts]

select getsrid(the_geom) from xxx_table;

will tell you what the srid id is set to for a geometry column in a table
xxx_table;

update xxx_table set the_geom=setsrid(the_geom,4326)

Will set the srid value for a column called the_geom in a table called
xxx_table

You can use qgis to checked your datavalues, just ask it to import a
postgis table and will will draw information.
D.


Annu Anurag wrote:
> I just checked the srid field in the geometry_columns. Its -1. I think
> that
> is causing the problem? I'm using the dataset of Delhi. It should run on
> srid=4326. How do I change it to EPSG: 4326 in my geometry column?
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>


--