On Tue, 12 Mar 2019, DelazJ wrote:
Hi,
Le mar. 12 mars 2019 à 14:55, Max Pyziur <[email protected]> a écrit :
On Tue, 12 Mar 2019, Richard Duivenvoorde wrote:
> Ah...
>
> Now I see 2.7 ????
> That is very old, please upgrade to the one available via
> https://qgis.org/en/site/forusers/alldownloads.html#fedora
Much thanks for your replies.
I've done this, but this has led to another issue. Either it's a bug or
I'm not executing something correctly (clicking checkboxes etc.
If I go Database -> DB Manager
Establish a connection to my postgresql/postgis database
F2 to open the SQL editing window, type:
SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'
Hit Execute, Load As layer
At this point, the dialog expands new options in which you may need to indicate
the PK and the geometry fields.
And then press on "Load" to have layer and features in the application.
Are these options not visible? Or do you simply skip these steps in your
feedback?
I do all of these things:
insert a SQL statement:
SELECT * FROM "shapefiles"."us_states"
Click "Execute"
The results appear
Click "Load As New Layer"
Check "Column(s) with unique values"
Click "Retrieve Values"
Add a layer name in the appropriate window
Click "Load"
And nothing shows up.
But if I go to the Layer -> Add Layer -> Add postgis layers
It loads appropriately from a table containing shapefile data.
I can then edit the SQL foundation of that layer, something like
SELECT * FROM "shapefiles"."us_states"
adding
SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'
and the results are
reflected.
I've been using QGIS since 2012, and this is a first for me.
Max
Harrissou
Nothing appears in either the Layers pane or the main window.
However, if I go
Layer -> Add Layer -> Add PostGIS Layers
and then select a table built upon a shapefile
the map loads.
I can then edit the SQL for that layer by right-clicking on the layer in
the layer pane, Update sql, and my modifications are reflected in the
layer.
How do I get DB Manager to add a layer?
Much thanks,
Max Pyziur
> Regards,
>
> Richard Duivenvoorde
>
>
> On 12/03/2019 07.08, Richard Duivenvoorde wrote:
>> Hi Max,
>>
>> The error means that the python-cpp bridge is not working because wrong
>> paths to (python) libs.
>> Are you maybe in a Python Virtual Environment at that moment, which in
>> that case screws up your python path?
>>
>> Or else: did you miss some QGIS-Python package (if installed via
package
>> manager)?
>>
>> Regards,
>>
>> Richard Duivenvoorde
>>
>> On 11/03/2019 23.15, Max Pyziur wrote:
>>>
>>>
>>> Greetings,
>>>
>>> My use of QGis Desktop is occassional; when I do use it, I construct
>>> layers using PostGIS & PostgreSQL.
>>>
>>> The key component that facilitates this in QGis is a Python plugin
>>> called DB Manager.
>>>
>>> When I started Qgis today, there was an error message that appeared
>>> something like this:
>>>
>>> Couldn't load PyQGIS. Python support will be disabled.
>>>
>>>
>>> Traceback (most recent call last):
>>> File "", line 1, in
>>> File "/usr/lib64/python2.7/site-packages/qgis/gui/__init__.py", line
>>> 27, in
>>> from qgis._gui import *
>>> RuntimeError: the PyQt4.QtCore module failed to register with the sip
>>> module
>>>
>>>
>>> Python version:
>>> 2.7.15 (default, Oct 15 2018, 15:26:09)
>>> [GCC 8.2.1 20180801 (Red Hat 8.2.1-2)]
>>>
>>> QGIS version:
>>> 2.18.20 'Las Palmas', exported
>>>
>>> After clicking away the error away, the existing layers that I had
built
>>> using PostGIS/PostgreSQL were still available in my key critical
project.
>>>
>>> However, when I went to look for DB Manager, it wasn't available.
>>>
>>> After some searching, I upgraded to QGIS 3.6 from a non-Fedora
>>> repository (the guidance is here:
>>>
https://stackoverflow.com/questions/53716778/the-pyqt4-qtcore-module-failed-to-register-with-the-sip-module)
>>>
>>>
>>> and now I have access to the DB Manager functionality.
>>>
>>> Is the Fedora/QGis community aware of this issue?
>>>
>>> Thanks!
>>>
>>> Max Pyziur
>>> [email protected]
>>> _______________________________________________
>>> Qgis-user mailing list
>>> [email protected]
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>> _______________________________________________
>> Qgis-user mailing list
>> [email protected]
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
> _______________________________________________
> Qgis-user mailing list
> [email protected]
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
