Re: BUG #15271: Documentation / Error reporting on GUC parameter change

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

On Tue, Aug 7, 2018, 22:53 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>