Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1qPxk1-00CY7Y-Dn
	for pgsql-bugs@arkaria.postgresql.org; Sun, 30 Jul 2023 04:09:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1qPxj0-007uDg-3f
	for pgsql-bugs@arkaria.postgresql.org; Sun, 30 Jul 2023 04:08:10 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1qPxiz-007uDY-LX
	for pgsql-bugs@lists.postgresql.org; Sun, 30 Jul 2023 04:08:09 +0000
Received: from mail-pg1-x52b.google.com ([2607:f8b0:4864:20::52b])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1qPxiw-002KTA-AK
	for pgsql-bugs@postgresql.org; Sun, 30 Jul 2023 04:08:08 +0000
Received: by mail-pg1-x52b.google.com with SMTP id
 41be03b00d2f7-55b1238cab4so2074758a12.2
        for <pgsql-bugs@postgresql.org>; Sat, 29 Jul 2023 21:08:06 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20221208; t=1690690085; x=1691294885;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to;
        bh=TRqxOMpwfXLZI8mMxGVo/pK6sjPi8bibZb1ZGloEomg=;
        b=c+7sqhFKcqfO8boPGMmDPlJ4r0myWXBDLUvQEnFuDUjJfB8NlMEahtE+NJUT1xZBcR
         xdq6Eg8ROdiFpiHQdBI4f7Erv927AK0mF4udUUnx9xc9HcDVVECY+JLdgvSIEgA8r9zF
         WTZWfxT4b9GvDwLG77Ou4YPS55DWtymwv6TMa8SjU9h2PlqMBfxUv+1ytxrEkuvJNOZr
         AQ1/RmPd6EgCx923EJ+hsFzs12/ubwOSkkeFOzRE7qIap0CAx27hIcAiJdVGDNn7jScX
         K3VyYZ9hFEg1o+7RznxAi5z1FqG3yTvXasoXJQ1KRmtVhrmIsktcURls0IA15OePUYg8
         95Fg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20221208; t=1690690085; x=1691294885;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date
         :message-id:reply-to;
        bh=TRqxOMpwfXLZI8mMxGVo/pK6sjPi8bibZb1ZGloEomg=;
        b=IGc4RJd8ReKrb9xSbqCYeAqQQRINTrAHRgEFlf8ZxSUY7ANUoMV5un/8qXiAL6Vn5N
         KNd9+mE2OnyAAB88iWOGNI0rXvxJAjH5m1hl6m1xmAgs9rHyCSLhgpsyi8GDl4phFKyc
         cD2rYEMjP939Z0nuFNKm0zr+NBunOKsCzM+aZHFbj6qTVxknkEx0JHoSNNnaHiF0onzC
         fTWPiwL1/+3IoqCSgufDiI3UjBI0gbbkiUvMJ/LFYj75BNlsFjzgSRVnTyJo0HUujW7c
         6ucmEzkRsti3j72tLyrAY4ksi9yUG71UBf18l16vaqwjFVNs5M04AEJrcK/71u8LoqQO
         Qapw==
X-Gm-Message-State: ABy/qLa1LMVHCFRY19/t8yKEh16Dk1VoVFKaH2qqfe6KJDiN9l1uORWI
	qwhqAEM43xW5At2McuQOddTkt6k2TL4=
X-Google-Smtp-Source: 
 APBJJlEvPeFcpJOD7IDDbzXXyGOGGaePxBZmpdVg+RsbXwBY4i1SJanQsOVCAEw7KuGc54+fK2zghw==
X-Received: by 2002:a17:90a:c254:b0:268:1d18:a19f with SMTP id
 d20-20020a17090ac25400b002681d18a19fmr6282171pjx.25.1690690084742;
        Sat, 29 Jul 2023 21:08:04 -0700 (PDT)
Received: from nathanxps13 ([50.47.162.83])
        by smtp.gmail.com with ESMTPSA id
 t16-20020a17090aba9000b0026307fa0442sm5973672pjr.49.2023.07.29.21.08.03
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Sat, 29 Jul 2023 21:08:04 -0700 (PDT)
Date: Sat, 29 Jul 2023 21:08:02 -0700
From: Nathan Bossart <nathandbossart@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: search_path not recomputed when role name changes
Message-ID: <20230730040802.GA284134@nathanxps13>
References: <186761d32c0255debbdf50b6310b581b9c973e6c.camel@j-davis.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <186761d32c0255debbdf50b6310b581b9c973e6c.camel@j-davis.com>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/20230730040802.GA284134%40nathanxps13>
Precedence: bulk

On Thu, Jul 27, 2023 at 11:21:25AM -0700, Jeff Davis wrote:
> The fix is simple, attached.

LGTM

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com