Hi,
Please find the patch to fix RM #2993 : [Web Based] User can not view data
for View and MATERIALIZED View object.
Thanks,
Khushboo
diff --git a/web/pgadmin/tools/sqleditor/__init__.py b/web/pgadmin/tools/sqleditor/__init__.py
index 84c98d3..aeca5cc 100644
--- a/web/pgadmin/tools/sqleditor/__init__.py
+++ b/web/pgadmin/tools/sqleditor/__init__.py
@@ -434,8 +434,10 @@ def start_view_data(trans_id):
sql = trans_obj.get_sql()
pk_names, primary_keys = trans_obj.get_primary_keys(default_conn)
- # Fetch OIDs status
- has_oids = trans_obj.has_oids(default_conn)
+ has_oids = False
+ if trans_obj.object_type == 'table':
+ # Fetch OIDs status
+ has_oids = trans_obj.has_oids(default_conn)
# Fetch the applied filter.
filter_applied = trans_obj.is_filter_applied()