Yeah I guessed as much :(
It's definitely something worth mentioning in the docs with a fat warning sign though.
Thanks for looking into it.
Akos
Akos Vandra <axos88@gmail.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
