[Qgis-developer] QGIS 2.6 - Open postgis raster: decimal separator problem?
Jorge Gustavo Rocha
jgr at di.uminho.pt
Thu Nov 13 17:00:01 PST 2014
Hi devs,
I'm unable to open Postgis rasters using the default language setting,
which is pt_PT.UTF-8 in my case. By overriding language settings, I can
open Postgis rasters. Maybe something related with the decimal_point
setting in LC_NUMERIC?
I didn't find any bug related with this issue. Can some else confirm
this problem? Should I submit a bug?
How to reproduce the problem (if decimal_point == ',' and not '.'):
0) Download raster from https://bo5r0b.s.cld.pt or use your own raster
i) Insert raster in to Postgis
raster2pgsql -d -I -C -M -s 3763 001972Argb_12.tif -F -t 1000x1000 orto
| psql -h localhost -U geobox -d orto
ii) Open QGIS with default language settings.
Add raster to QGIS using DB Manager
iii) The raster does not show properly. Raster properties are not
extract/calculated correctly.
How to solve the problem:
i) Start QGIS overriding all language specific settings:
LC_ALL=C qgis
ii) The Postgis raster shows properly and all properties are loaded with
correct values.
I'm using:
Ubuntu 14.04.1 LTS
"PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit"
"POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0,
6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1"
LIBJSON="UNKNOWN" RASTER"
QGIS version 2.6.0-Brighton QGIS code revision exported
Compiled against Qt 4.8.6 Running against Qt 4.8.6
Compiled against GDAL/OGR 1.10.1 Running against GDAL/OGR 1.10.1
Compiled against GEOS 3.4.2-CAPI-1.8.2 Running against GEOS
3.4.2-CAPI-1.8.2 r3921
PostgreSQL Client Version 9.3.4 SpatiaLite Version 4.1.1
QWT Version 5.2.3 PROJ.4 Version 480
QScintilla2 Version 2.8.1
Additional feedback is appreciated.
Regards,
J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor
More information about the Qgis-developer
mailing list