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()