[postgis-users] How to join Two points(latitudes and langitudes) in postgis?

[Michael Diener]

Hi Siddhesh

In qGIS the SRID must be properly defined when changed from -1 to draw on
screen.  So you have to make sure your dataset SRID is properly defined.
Use the updategeometrySRID function to update your SRID from -1 to ####
here is an example

--usage  
select updategeometrySRID('tableName','geometry_columnName','newSRID
number');
select updategeometrySRID('myTableName','geom',31255);

then your linestring should be drawn.


Cheers
michael