postgresql - 使用匿名函数更改 work_mem 失败
问题描述
show is_superuser
结果为 ON。这意味着现在我的用户/角色是管理员并且是超级用户。根据随附的教程执行以下代码:
Do $_$
Declare r record;
BEGIN
FOR r in select u.rolname
from pg_authid U
join pg_auth_members m on m.member = u.OID
join pg_authid g on g.oid = m.roleid
where g.rolname = 'admin'
loop
execute $$ alter role $$ || r.rolename || $$ set work_mem = '128MB' $$;
end loop;
end $_$;
然后执行以下代码:
select u.rolname, s.setconfig as setting
from pg_db_role_setting s
join pg_authid u on u.oid = s.setrole
join pg_auth_members m on m.member = u.oid
join pg_authid g on g.oid = m.roleid
where g.rolname = 'admin';
我的结果显示零行,然后我尝试使用show work_mem
,结果仍然是 4MB。这样,我相信它显示了 128MB,根据这两张幻灯片。幻灯片链接:http: //joeconway.com/presentations/fun_with_functions-PGConf.US-2015.pdf
解决方案
推荐阅读
- unit-testing - 无法使用 Mockito.when 存根 ReactiveMongoRepository
- javascript - 如何使用 reduce 方法返回一个跟踪数组中特定字符实例的对象?
- javascript - 将值传递给 JSON Post 请求
- javascript - javascript function with variable needed to trigger a url with value from within script
- javascript - 使用 document.body.classList.add 添加类以在页面加载时提供元素
- python - Insert Data into MongoDB Atlas from Python ( from one function to other) - how to insert?
- python - Python 3.6 matplot lib error: AttributeError: module 'matplotlib' has no attribute 'projections'
- c++ - C++ writing JSON with JSONCPP
- javascript - 使用 javascript/jquery 将数组转换为键和值的对象
- java - @ControllerAdvice does not allow Swagger UI to be displayed