Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB Manager unable to show PostGIS geography column #37666

Closed
tjukanovt opened this issue Jul 8, 2020 · 0 comments · Fixed by #39154 or #39183
Closed

DB Manager unable to show PostGIS geography column #37666

tjukanovt opened this issue Jul 8, 2020 · 0 comments · Fixed by #39154 or #39183
Assignees
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin

Comments

@tjukanovt
Copy link

Describe the bug
DB Manager is unable to show the contents of a column of geography type from PostGIS

How to Reproduce

I imported a point layer to my local PostGIS (3.0, PG 11). I added a geography type column:
ALTER TABLE foo ADD COLUMN geog geography(POINT,4326);
I created points to that column based on the geometry column:

UPDATE foo
SET geog =
ST_GeogFromWKB(st_asewkb(geom))

But after this if I do a select statement, I can't see the geography columns or the contents. SELECT geog from foo returns nothing. In pgAdmin v4 the column works fine and it's also visible in the QGIS layer browser, but not in DB Manager.

QGIS and OS versions

QGIS version
3.14.0-Pi
QGIS code revision
9f7028f
Compiled against Qt
5.11.2
Running against Qt
5.11.2
Compiled against GDAL/OGR
3.0.4
Running against GDAL/OGR
3.0.4
Compiled against GEOS
3.8.1-CAPI-1.13.3
Running against GEOS
3.8.1-CAPI-1.13.3
Compiled against SQLite
3.29.0
Running against SQLite
3.29.0
PostgreSQL Client Version
11.5
SpatiaLite Version
4.3.0
QWT Version
6.1.3
QScintilla2 Version
2.10.8
Compiled against PROJ
6.3.2
Running against PROJ
Rel. 6.3.2, May 1st, 2020
OS Version
Windows 10 (10.0)
Active python plugins
DigitransitGeocoder;
GlobeBuilder;
Hqgis;
KuntagmlLoader;
pgRoutingLayer;
Qgis2threejs;
qgis_resource_sharing;
timemanager;
db_manager;
MetaSearch;
processing

@tjukanovt tjukanovt added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Jul 8, 2020
@gioman gioman added the DB Manager Relating to the DB Manager core plugin label Jul 8, 2020
@elpaso elpaso self-assigned this Sep 24, 2020
elpaso added a commit to elpaso/QGIS that referenced this issue Oct 3, 2020
elpaso added a commit to elpaso/QGIS that referenced this issue Oct 5, 2020
1. expose geometry fields for PG Fixes qgis#37666
2. add a warning message when deleting a pk
3. add a warning message when deleting a geom col
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin
Projects
None yet
3 participants