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 ) id 1qTsLs-00Axiq-Ea for pgsql-committers@arkaria.postgresql.org; Wed, 09 Aug 2023 23:12:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qTsLq-009510-QN for pgsql-committers@arkaria.postgresql.org; Wed, 09 Aug 2023 23:12:27 +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 ) id 1qTsLq-00950s-Gy for pgsql-committers@lists.postgresql.org; Wed, 09 Aug 2023 23:12:26 +0000 Received: from mail-pf1-x433.google.com ([2607:f8b0:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qTsLk-001Tlq-2B for pgsql-committers@lists.postgresql.org; Wed, 09 Aug 2023 23:12:25 +0000 Received: by mail-pf1-x433.google.com with SMTP id d2e1a72fcca58-68706b39c4cso240764b3a.2 for ; Wed, 09 Aug 2023 16:12:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1691622739; x=1692227539; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=/25B/RsGz9EyzssuHdgpV5aBaw7RlWlQ20+Y85Kgrn8=; b=u5QSpooPuJ64SEyXz3Cy12g0h3eP0bTaqgJ+5IuOoU9yoQu1t2wkR46wgQ6Ob5pPtr toL0p9BHxj/MbUKimDatEZ1FR9TXhhzHQGUt5NqKIjjbM+MM7Adaf4f03fQ1BsuReaMN qiY0JBS+7NQ9QOzBW7+fEdVixVbqopYrXnzUqhsyB58Yd8BwA2G3mvODXh8S9rUbFdZ2 BElrRSC2w9VsSN81ydWvOFILv/0c6HWWa8YrlrUNxvmpaW/K/WslPwxslotyofe/NBLF wrOrOhgLjW/Zbdrzsj2gVskLQsFsdGI5VkWQQqf8OjhEaLbkiS2ULoG3ANjpulIL5JMk oefg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691622739; x=1692227539; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=/25B/RsGz9EyzssuHdgpV5aBaw7RlWlQ20+Y85Kgrn8=; b=DFSYUzcwqx639InadT/mL/0qJFO5Q0FVX+jUASJVydrd/SnkzqxVbjzJ59/aXy05p0 hMoY/8a8tK+J7xp+QbEpKdVoqFwoQDZ/RTgeJMZVXBzH7mA/KDGsSzN68PA7pW7U71u9 7HHOzO2JkoJ5DlEiFGDOYD+moYw8uvo3k5xd8zHaqJhqGpDpDhlEuyBlLsaRmeUt+A8J w5/5euK2WMyWk7yJj+Il3FQXrnSrqGZjWrfZlY0yHEyIJkmInXl7But1ddfWvOqCCayb Etmd4gZiqp+VE09g8FotOyC0+UMoofWLL9jJjhWgJ/yf7IBNDJJT3gGwT+NUOW65v/D+ Mxhw== X-Gm-Message-State: AOJu0Yz+jo1gkopFZuOQPywbMZIXt79jw8SRbrf9+eHRjKq9B6PNVKyT +z2jFRmFZw1i4jx+A896WRfOPA== X-Google-Smtp-Source: AGHT+IFn6QcFS9fBZ8JWNPtCDNT6R7oOeMLjXd97bVO35ntabJCtwwtH6beHsrmyrcEjfjPXZdfKzQ== X-Received: by 2002:a05:6a00:cc2:b0:682:4b93:a4d3 with SMTP id b2-20020a056a000cc200b006824b93a4d3mr681548pfv.1.1691622738545; Wed, 09 Aug 2023 16:12:18 -0700 (PDT) Received: from jeff-laptop.lan (c-98-45-81-55.hsd1.ca.comcast.net. [98.45.81.55]) by smtp.gmail.com with ESMTPSA id n23-20020a62e517000000b0064f76992905sm117216pff.202.2023.08.09.16.12.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 09 Aug 2023 16:12:18 -0700 (PDT) Message-ID: Subject: Re: pgsql: Recalculate search_path after ALTER ROLE. From: Jeff Davis To: Jeff Davis , pgsql-committers@lists.postgresql.org Date: Wed, 09 Aug 2023 16:12:15 -0700 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-08-09 at 20:31 +0000, Jeff Davis wrote: > Recalculate search_path after ALTER ROLE. Looks like this is causing some buildfarm failures for debug_parallel_query members related to the combination of parallel query, search_path, and renaming a role. I'm not sure yet, but this looks like a possible pre-existing bug, or some incorrect assumption I made in fa2e874946. Investigating... Regards, Jeff Davis