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?