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-boun...@lists.osgeo.org [mailto:postgis-users-boun...@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@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users