Akos Vandra <axos88(at)gmail(dot)com> writes:
> But the problem persists even as the database owner, I can't ALTER DATABASE
> (as the db owner) before the extension is loaded into the session.
> Actually that was the original issue. Non-owners or non-superusers can't
> use ALTER DATABASE, and that's fine, but not even the DB OWNER can use
> ALTER DB before a SELECT set_limit(); in case of pg_trgm.
Yeah. It's a design limitation with no easy fix. You just have to
load the extension so that the code knows the properties of the variable.
regards, tom lane