我有一个档案数据库。我想为它设置一个参数default_transaction_read_only = ON。我有一个删除只读模式的函数。

create or replace procedure tmp_util_archive_set_db_read_only(IN pisreadlonly boolean)
    language plpgsql
as
$$
begin
 SET default_transaction_read_only to OFF;
 if pIsReadlOnly then
  ALTER database mpbr SET default_transaction_read_only to ON;
 elseif not(pIsReadlOnly) then
  set transaction read write;
  ALTER database mpbr SET default_transaction_read_only to OFF;
 end if;
end
$$;

但是当我调用它时，我得到一个错误

cannot execute ALTER DATABASE in a read-only transaction

是否可以使用函数使数据库脱离只读模式？

do
$$
    begin
        call tmp_util_archive_set_db_read_only(pisreadlonly := false);
    end
$$;