91 reputation
17
bio website geographer.gr
location
age
visits member for 2 years, 3 months
seen 5 hours ago

Nov
21
comment How to prevent users to remove qgis layer?
With QgsMapLayerRegistry.instance().layersWillBeRemoved.disconnect(QgsMapLayerRegist‌​ry.instance().removeMapLayers) I get TypeError: 'builtin_function_or_method' object is not connected
Nov
18
asked How to prevent users to remove qgis layer?
Nov
11
awarded  Popular Question
Oct
2
asked How to change color ramp in graduated classification with standard deviation using pyqgis
Sep
30
comment Does qgis support postgresql range types?
I'm able to load the postgis table in Qgis but the date column field is not listed in table.
Sep
30
asked Does qgis support postgresql range types?
Sep
27
comment Standard deviation classification in QGIS
Yes, but how can I display values above and below the mean. Like that in the example:http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Standard_‌​deviation
Sep
27
asked Standard deviation classification in QGIS
Sep
24
awarded  Teacher
Sep
24
answered Why doesn't QGIS automatically find the new plugin update during startup?
Sep
23
asked Why doesn't QGIS automatically find the new plugin update during startup?
Sep
5
comment How to load style from postgresql?
I'll check it.What's the format of uri?like that? uri=u'dbname=\'dbname\' host=localhost port=5432 user=\'leonidas\' password=\'xxx\' table=\'layer_styles_table_name'\ () sql='
Sep
5
awarded  Curious
Sep
4
asked How to load style from postgresql?
Sep
2
awarded  Supporter
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
Also, the code works only if I don't define schema in DataSource:uri.setDataSource("",sql,"the_geom","","ID")
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
I did CAST(coalesce(ID, 0) AS integer) as ID to cast to integer and now it works fine. Thank you for your help!!!
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
I think that's the problem. The field is character varying. I check it with other data with smallint and it works. But the datasource should be "postgres" not "postgis", else it doesn't work. What are the appropriate data types? Is it possible to use a character varying field?
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
Now I get: Failed to load:unknown error
Sep
2
revised Cannot load postgis layer from sql string in pyqgis
Added Qgis version