Re: BUG #15271: Documentation / Error reporting on GUC parameterchange - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #15271: Documentation / Error reporting on GUC parameterchange
Date
Msg-id 20180807214306.GL7297@momjian.us
Whole thread Raw
In response to Re: BUG #15271: Documentation / Error reporting on GUC parameter change  (Akos Vandra <axos88@gmail.com>)
List pgsql-bugs
On Tue, Aug  7, 2018 at 11:11:16PM +0200, Akos Vandra wrote:
> Yeah I guessed as much :(
> 
> It's definitely something worth mentioning in the docs with a fat warning sign
> though.

We do have a _vague_ warning sign.  ;-)

---------------------------------------------------------------------------


> 
> Thanks for looking into it.
> Akos
> 
> On Tue, Aug 7, 2018, 22:53 Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
>     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
> 

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


pgsql-bugs by date:

Previous
From: Akos Vandra
Date:
Subject: Re: BUG #15271: Documentation / Error reporting on GUC parameter change
Next
From: PG Bug reporting form
Date:
Subject: BUG #15316: pg_restore failes to load data that is constrainted by afunctional check constraints