3

I have a table of around 800000 records with POINT geometry in PostgreSQL/PostGIS. When I directly open the table in QGIS, the attribute table opens fine and the fields are populated.

But when I open the View of same exact table, "ERROR" is populated in all fields in the attribute table.

If I reduce the size of the table or reduce columns then the attribute table opens fine for a View as well.

I dont know what is the problem. Is there some memory limitations for a view in QGIS?

This is what attribute table of a view of same tables look like.

Improve this question
1
  • 1
    I definitely think this should NOT be closed. It contains valuable information with the answer below!
    – Matthias Kuhn
    Oct 25, 2018 at 12:35

1 Answer 1

Reset to default
4

Solved it. Memory was not an issue. QGIS was not able to get a unique key of that view. Placed that key in the start and it worked fine.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.