-
Notifications
You must be signed in to change notification settings - Fork 3
Open
Description
The current implementation takes into account all tables which names are prefixed by the current user name:
RETURN QUERY SELECT JSON_AGG(vals) as src FROM ( SELECT pg_size_pretty(SUM(pg_total_relation_size(quote_ident(table_name)))) AS "usage" FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE user_name || '%' ) AS vals;
This occurs twice in geodb.sql:
- in
geodb_get_user_usage(geodb_get_user_usage(user_name text, pretty BOOLEAN))
- in
geodb_get_user_usage(user_name text)
A correct implementation would consider only those tables owned by the current user.
Metadata
Metadata
Assignees
Labels
No labels