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.

Sign up for GitHub

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

Jump to bottom

QGIS 3.10 can't find pkey of postgres views #34167

Closed
kadarivan opened this issue Jan 31, 2020 · 3 comments · Fixed by #34179
Closed

QGIS 3.10 can't find pkey of postgres views #34167

kadarivan opened this issue Jan 31, 2020 · 3 comments · Fixed by #34179
Assignees
@elpaso
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Feedback Waiting on the submitter for answers Regression Something which used to work, but doesn't anymore

Comments

@kadarivan
Copy link

Since QGIS 3.10 the program randomly select a 'key' field for postgres views, so can't open them from Browser Panel, only from the Data Source Manager, after I manually select the Feature id
Previous versions respect field order from definition of views, but 3.10 sort them randomly in the Feature id selection list.

QGIS 2.18 and 3.4 are working fine. I only use LTR versions, so don't know when it changed.

client:
QGIS 3.10.2 Windows 10

server:
PostgreSQL 9.6.5, compiled by Visual C++ build 1800, 64-bit
PostGIS 2.4

3.4:
DSM_qgis3_4
3.10:
DSM_qgis3_10

3.4: DSM_qgis3_4_order 3.10: DSM_qgis3_10_order
@kadarivan kadarivan added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Jan 31, 2020
@elpaso
Copy link
Contributor

elpaso commented Jan 31, 2020

please share a db SQL dump and a project to reproduce.

@elpaso elpaso added the Feedback Waiting on the submitter for answers label Jan 31, 2020
@elpaso elpaso self-assigned this Jan 31, 2020
@elpaso elpaso added the Regression Something which used to work, but doesn't anymore label Jan 31, 2020
@kadarivan
Copy link
Author

pkey.zip

@gioman
Copy link
Contributor

gioman commented Jan 31, 2020

please share a db SQL dump and a project to reproduce.

I also noticed this issue. If the provided sample is not enough let me know, i should be able to provide a sample of my own.

elpaso added a commit to elpaso/QGIS that referenced this issue Jan 31, 2020
@elpaso
Fix PG views PK
83eaa0e 
Fixes qgis#34167
@elpaso elpaso mentioned this issue Jan 31, 2020
Merged
nyalldawson pushed a commit that referenced this issue Feb 2, 2020
@elpaso @nyalldawson
Fix PG views PK
900166f 
Fixes #34167
elpaso added a commit to elpaso/QGIS that referenced this issue Feb 5, 2020
@elpaso
Fix PG views PK
b7bdb9a 
Fixes qgis#34167
@elpaso elpaso mentioned this issue Feb 5, 2020
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@elpaso elpaso

Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Feedback Waiting on the submitter for answers Regression Something which used to work, but doesn't anymore
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix PG views PK elpaso/QGIS
3 participants
@elpaso @gioman @kadarivan