[postgis-users] Incorrect geometry_columns?

[Francois Hugues]

Hi,

Are you sure you don't have mixed srid ?

You should try this instead of limit 1 :
Select st_srid(geom) from merge_strade group by st_srid(the_geom)

Hugues. 


-- 
Hugues FRANÇOIS 
Ingénieur recherche 

Irstea Grenoble 
2 rue de la papeterie 
38400 Saint-Martin d'Hères 

tel : +33 (0)4.76.76.27.44 
port : +33 (0)6.77.66.21.31 
fax : +33 (0)4.76.51.38.03
 

-----Message d'origine-----
De : postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] De la part de Paolo Cavallini
Envoyé : dimanche 9 décembre 2012 11:21
À : PostGIS Users Discussion
Objet : [postgis-users] Incorrect geometry_columns?

Hi all.
The geometry_columns view appears incorrect:

=> SELECT * from geometry_columns  where f_table_name='merge_strade'; f_table_catalog|f_table_schema|f_table_name|f_geometry_column|coord_dimension|srid|type
prova|public|merge_strade|geom|2|0|GEOMETRY

SELECT ST_SRID(geom) FROM merge_strade LIMIT 1; st_srid
3003

SELECT ST_geometrytype(geom) FROM merge_strade LIMIT 1; st_geometrytype ST_LineString

Am I missing something?
Thanks.
--
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario _______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users