Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q9AX4-0000LA-CY for pgsql-committers@arkaria.postgresql.org; Tue, 13 Jun 2023 20:22:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9AX3-0003Kw-4J for pgsql-committers@arkaria.postgresql.org; Tue, 13 Jun 2023 20:22:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q9AX2-0003Km-T6 for pgsql-committers@lists.postgresql.org; Tue, 13 Jun 2023 20:22:24 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q9AWz-0021vH-Gq for pgsql-committers@lists.postgresql.org; Tue, 13 Jun 2023 20:22:23 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-51878f8e541so1422495a12.3 for ; Tue, 13 Jun 2023 13:22:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1686687740; x=1689279740; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=daU0HfjcRn4HganakmsZuyo0M0oexOwB/wTfYVS/oBE=; b=SBh3ISti2VHhsymrNmD5JHjzoUQ0qSG9p+RdnvtScLBQn66ZMZX52RpE2RVDC52uYU AexkvzMZ8TCCSaurf4Ig1QwvuuI7gQMpYiVuinui7QnCT3epuwQP67Dhwfaq46lvf79l yMk3VKTOXHzdybirwUnLsCSz7b6fb1+rYHqAmjUiD4OHB3ZKZ+bmp9FxkHC7VTPITEyM nGhG/d0xZxqpdLG6SKAGB1wAU4Fff6sLKxF2ys+iEjmDUjZ06cxDtQnILVNUFhpuw1t2 +W6Q3GK/N/Oucdm3afmvINhUskWba3jmpSB8nOgC0I+qYaAitBog0jIQT6gThvHFcn41 xD9g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686687740; x=1689279740; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=daU0HfjcRn4HganakmsZuyo0M0oexOwB/wTfYVS/oBE=; b=OY01bhfAyS0DQlXh8Cu7BgKELCfstOAZurvaWEH/Z6Sd3CXS0Vq8wENXhuCkWAdp+X keShIyls8V5F17WIEurOjQAkrMZQwdzIJus/kCrc+agrqO6n1Kc6BjjhJTsOOT2e7toK PtPNjlmh1pKeudBhhJan21wd5QZk9+JZgRyj2xir2hb1fOn3m3niDtHitd+RhddQ6Sp2 6u18aILD8hJ+UXeIC7528usFG9jHZWUpdSo/1h4DlrYAo4hzIoG0bEQEdvibVURaOrQ6 6XmUqm4hcfiWkVtFBY+mhMf3w102LYUjxlNwKqogaJWEA43tRpkxuB7rQ7GPJsOt3aTO Z9DA== X-Gm-Message-State: AC+VfDyE4S4EJrBxp/YPDfY+9dh8LeoLkPSbc9+eEAqBrtVQhmJwTv6N eeYjPuCi6LiHBA8+sScsSmeVILxcranDgoz1tlQ= X-Google-Smtp-Source: ACHHUZ6Gipe6L7GnU80YG9GfHyEJ4PhGgxs0RKotSDddS1BJNBF+rAOz5w84oPaPn4nqEK9aSUdXvL2dHf3RCp5OVQ0= X-Received: by 2002:aa7:db94:0:b0:518:3102:9363 with SMTP id u20-20020aa7db94000000b0051831029363mr5540381edt.40.1686687739472; Tue, 13 Jun 2023 13:22:19 -0700 (PDT) MIME-Version: 1.0 References: <89a415b86d5421941e4281ba5bf6288934078624.camel@j-davis.com> <573014.1686375211@sss.pgh.pa.us> <20230612170510.GA201972@gust.leadboat.com> <32747058519a68f099ac175a3a4bde4ba7cebb22.camel@j-davis.com> In-Reply-To: <32747058519a68f099ac175a3a4bde4ba7cebb22.camel@j-davis.com> From: "David G. Johnston" Date: Tue, 13 Jun 2023 13:22:01 -0700 Message-ID: Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations. To: Jeff Davis Cc: Noah Misch , Tom Lane , Jeff Davis , "pgsql-committers@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000008ef2cd05fe0897cf" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008ef2cd05fe0897cf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jun 13, 2023 at 12:54=E2=80=AFPM Jeff Davis wro= te: > On Mon, 2023-06-12 at 18:31 -0700, David G. Johnston wrote: > > On a related note, are we OK with someone using this privilege > > setting their own default_statistics_target? > > > > > https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-DEF= AULT-STATISTICS-TARGET > > > > My prior attempt to open up analyze had brought this up as a reason > > to avoid having someone besides the table owner allowed to analyze > > the table. > > Thank you for bringing it up. I don't see a major concern there, but > please link to the prior discussion so I can see the objections. > > This is the specific (first?) message I am recalling. https://www.postgresql.org/message-id/A737B7A37273E048B164557ADEF4A58B53803= F5A%40ntex2010i.host.magwien.gv.at David J. --0000000000008ef2cd05fe0897cf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Jun 13, 2023 at 12:54=E2=80=AFPM Jeff Davis <pgsql@j-davis.com> wrote:<= br>
On Mon, 2023-06-12 at 18:31 -0700, David G. Johnston wrote= :
> On a related note, are we OK with someone using this privilege
> setting their own default_statistics_target?
>
> = https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-DEFAU= LT-STATISTICS-TARGET
>
> My prior attempt to open up analyze had brought this up as a reason > to avoid having someone besides the table owner allowed to analyze
> the table.

Thank you for bringing it up. I don't see a major concern there, but please link to the prior discussion so I can see the objections.


This is the specific (first?) message I am reca= lling.

= https://www.postgresql.org/message-id/A737B7A37273E048B164557ADEF4A58B53803= F5A%40ntex2010i.host.magwien.gv.at

David J.

--0000000000008ef2cd05fe0897cf--