PostGIS 2.0 Testing on various desktops

[robe]

Desktops to test - just itemizing issues so far that we need to address before release (either with an FAQ workaround or get the developers of these to revise)

GvSig? -- I know already gvSig 1.10 doesn't work with PostGIS 2.0 -- looks like they are using AsEWKB which I pulled out.

Others to test uDig -

QGIS 1.5 seems to work okay with 2.0

OpenJump? (I have just 1.3.1 need to check newer)-- Ad hoc Query tool works okay but Data Store layer doesn't seems to use obsolete Extent

pgRouting -- I think this will have issues too as last version I checked was I think using deprecated startpoint and endpoint functions among other things.

[robe]

On closer inspection -- QGIS has issues too. QGIS Info tool doesn't work because it uses

AsBinary?, intersects, and setsrid

[nicklas]

In QGIS this is solved in QGIS trunk (QGIS 1.7). They have nightly builds that I use. But quite annoying is that nightly build id built against Gdal 1.6.x but QGIS 1.6 is built against 1.7.x for Ubuntu. Have not successed to use the raster plugin with any of the versions. load raster to db works, but I have not been able to view the data in QGIS.

For gvSig there is also some trouble in 1.10 not passing the z-values. I had a patch from the developers to try 3D-extension. After some help from them I had it working. About ST_Asbinary I don't know if this was before AsBinary? was removed or if it was fixed in that patch. The z-issue should hopefully be fixes in release 1.11. I also had some troubles with connections hanging after I had removed the table from gvSig.

/Nicklas

[jef]

Replying to robe:

On closer inspection -- QGIS has issues too. QGIS Info tool doesn't work because it uses AsBinary?, intersects, and setsrid

Fixed in [ QGIS r15072]

[robe]

Jef, Thanks.

[robe]

Add to this list Mapnik. I tried generating OpenStreetMap tiles with my PostGIS 2.0 install, and it appears it uses at least the deprecated Extent function.

[robe]

Okay according to Dane Springmeyer the upcoming Mapnik 2.0 scripts will not use deprecated functions:

So will just have to test these against our PostGIS 2.0. springmeyer - "Mapnik trunk, aka Mapnik 2.0, uses the latest ST_* functions, not the older ones. It will likely be released in late summer, the same time as PostGIS 2.0."

See thread here:

 http://www.reddit.com/r/programming/comments/hgm1/building_tiles_with_postgis_openstreetmap_data/

[robe]

typo in last link:  http://www.reddit.com/r/programming/comments/hgm1r/building_tiles_with_postgis_openstreetmap_data/

[nicklas]

I just bumped into :

RuntimeError: Postgis Plugin: PSQL error:
ERROR:  function setsrid(box3d, integer) does not exist

when trying to generate tiles with Mapnik 2.0 from  http://ppa.launchpad.net/mapnik/nightly-trunk/ubuntu updated today.

In source I found it in their file: postgis_datasource.cpp

/Nicklas

[robe]

nicklas -- can you report this on thier bug tracker. I think I did that for other such issues.

Anyrate we have this function in legacy_compatibility_layer.sql

Give that a try to install and see if you run into other issues after that.

[nicklas]

Yes, I will report it.

I just installed setsrid, and it seems to work now.

So, probably they have fixed extent that you mentioned above.

[nicklas]

Ok, SetSRID issue is fixed in Mapnik trunk.  https://github.com/mapnik/mapnik/issues/1083

I guess it was not Mapnik 2.0 that I was testing as I wrote above but trunk, so I guess it will be in Mapnik 2.1

[pramsey]

Bad news from the MapServer? front, while I changed the ST_AsBinary call years ago, I had left in place a GeomFromText? call, so the current released MapServers? aren't going to work with PostGIS 2.0 out of the box. The next minor release to 6.0 will pick up the change though.

[pramsey]

GeoServer? 2.1.3 seems happy w/ 2.0. No problems encountered adding and viewing a table.

[robe]

I'm going to consider this done.