We're updating the issue view to help you get more done. 

Postgis/Gdal problem

Description

I wanted to build a topology network with Postgis

SELECT pgr_createTopology('route',0.001,'geom','gid','source','target');

This command does not support Z inside geom, so I applied this command

ALTER TABLE route ALTER COLUMN geom TYPE geometry(MultiLineString) USING ST_Force_2D(geom);

After that, I had no problem with Postgis and Qgis. But in MW, when I tried to load this "route" layer, I got the messages below.

Is it also related to GDAL version included in MW ?

Olivier

5 Debug GDAL FAILURE: message contents do not agree with length in message type "T"
lost synchronization with server: got message type "2", length 842479157 10:21:09.803
6 Debug GDAL FAILURE: socket not open 10:21:18.964
7 Debug GDAL FAILURE: Could not fetch SRS: socket not open 10:21:20.367
8 Debug GDAL FAILURE: lost synchronization with server: got message type "2", length 842479157 10:21:21.033
9 Debug GDAL FAILURE: lost synchronization with server: got message type "2", length 842479157 10:21:21.667
10 Debug GDAL FAILURE: lost synchronization with server: got message type "2", length 842479157 10:21:22.610
11 Debug GDAL FAILURE: lost synchronization with server: got message type "2", length 842479157 10:21:24.724
12 Debug GDAL FAILURE: lost synchronization with server: got message type "2", length 842479157 10:21:25.187
13 Debug GDAL FAILURE: lost synchronization with server: got message type "2", length 842479157 10:21:25.337

Then I dropped te connection in the repository and tried to reconnect. That's when I got :

14 Debug GDAL FAILURE: Bad extent representation: 'PROJCS["RGF93 / Lambert-93",GEOGCS["RGF93",DATUM["Reseau_Geodesique_Francais_1993",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6171"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4171"]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["standard_parallel_1",49],PARAMETER["standard_parallel_2",44],PARAMETER["latitude_of_origin",46.5],PARAMETER["central_meridian",3],PARAMETER["false_easting",700000],PARAMETER["false_northing",6600000],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","2154"]]' 10:24:12.414
15 Debug GDAL FAILURE: 10:24:13.863
16 Debug GDAL FAILURE: Could not fetch SRS: 10:24:15.006

Environment

None

Status

Assignee

Unassigned

Reporter

Olivier Leprêtre

Labels

Epic Link

Affects versions

v5.1.0.0

Priority

High