search

lutraconsulting / ostranslator-ii

A graphical QGIS plugin for loading Ordnance Survey MasterMap into PostGIS.
16 stars 8 forks source link

Problem with styling data #43

Closed saberraz closed 6 years ago

saberraz commented 6 years ago

I am testing the branch for QGIS 3 port and the upload to PostGIS seems to have worked. But all the data are in the SCHEMA_tmp and not the main schema defined by user.

saberraz commented 6 years ago

That is due to this error: All jobs completed successfully.

Failed to complete one or more post-processing tasks:

Post-processor error: operator does not exist: character varying @> unknown
LINE 7:  WHEN descriptivegroup @> '{Building}' AND descriptiveterm I...
                               ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

You opted to apply the default OS style. Please ensure you also set up SVG paths and fonts for those who will be using the layers. See http://www.lutraconsulting.co.uk/products/ostranslator-ii/ for more information.

Loaded in 0.0 hours (16 seconds).
saberraz commented 6 years ago

Here are my settings for both QGIS 3 and 2.18. Works fine with 2.18 and comes up with the above error in master. image

saberraz commented 6 years ago

From the tmp schema, it appears that the plugin has not created descriptiveterm column.

sklencar commented 6 years ago

Regarding missing descriptiveterm column, fixed in commit https://github.com/lutraconsulting/ostranslator-ii/commit/d103acef72a8e6c396aa12976132bceb4aff8f2b.