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 1s9qAf-005SDb-JO for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 17:54:38 +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 1s9qAf-001wN8-Jb for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 17:54:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9qAf-001wN0-8G for pgsql-general@lists.postgresql.org; Wed, 22 May 2024 17:54:37 +0000 Received: from mail-oi1-x231.google.com ([2607:f8b0:4864:20::231]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s9qAc-000EmZ-Km for pgsql-general@postgresql.org; Wed, 22 May 2024 17:54:36 +0000 Received: by mail-oi1-x231.google.com with SMTP id 5614622812f47-3c999d53e04so3268301b6e.2 for ; Wed, 22 May 2024 10:54:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1716400473; x=1717005273; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=IXS05EYJ2lbw1K2eKLip7bg7qBLZEAzlPBm7rvhjuQg=; b=eJOYHVnp82YUR5y0UO/ZVMeklDp8gIem7Z+/S5lvdefbfI5pI8/fJjHfTJmxbRmbvV C1NdS1ZJxfxORP/PWVdufPzdXtcFlcarebpdfACB7mgmXRY62LyNk6sj05vu+9eqru4+ cXbHxJSwo5MjjgXhxaEWWg/7WHlGlwE9wHudsFQ2PALA7B0sfBe4TiPxZv52rDA79BpD mjUfxfGC8aF9/oPVVBDfzWx4cjQ8OQhdnpIC2nzgmDeFq8p/sBadDdLX6ixgWLYA9hVa 9cbaldBcGEzYaTm0fcMRnbbW2LddoA6auRGWojvuU6w8MI5ZZQfyhskzmL2/zRGm7KvJ qrHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1716400473; x=1717005273; h=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=IXS05EYJ2lbw1K2eKLip7bg7qBLZEAzlPBm7rvhjuQg=; b=G8VoeN8yOgKR6O4b+UhztT1IePxgAQDMhY3k4Z4RAFse3uZB4BTUvEyEzlw5+haiw2 c6L5AzSoeVeQcmhF9uPbBezQ38QnOEZu9BwEy3jdTvlthRi32I8TBwAYe4QIpko21YzW wg2LxYVwW11mUiNRFcRdOaIOKjLLNdgJ3UuvnJlaB9ErSAdPKFFq3bXxX2ui2ubfWtGB W72j0V9iz9H/wrmJ4dX+h97NEc0iwq0vkQqnp37TyGj8zvlxhh+3UkL8eigz5Um8Dkgr JcFl1gsqIra3BYMRQwNP5Dw2IDSGZ7zNWcjtjgAIrs7iSAYUnmXro6uIyNE0j0cTccIX u2EQ== X-Gm-Message-State: AOJu0YxNn0IKSojM7ott/OF+VTdtpdjPNZp3XReQBa9Ve0hTVvIDMFcJ +CWuVcZJBBf+IuXCGx3/ucsWw0fgsoWIAchuhOtJ/zbTBZ95IJpOC9kbXDZNscxjE1u1QjxFNLe /G5Aexl85O7sKtIkplgO6LtgKOvhjzYPw X-Google-Smtp-Source: AGHT+IE80ErqBNEgI7WrlEs/v9U5K3I4TwnMGcydQjDgOOEShFgqTgo14CQu2B3hGfE316YvHdTNUuzSNbwVOeJsrfE= X-Received: by 2002:a05:6870:2b15:b0:24c:6477:13c7 with SMTP id 586e51a60fabf-24c68d06201mr2953835fac.13.1716400472817; Wed, 22 May 2024 10:54:32 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Wed, 22 May 2024 13:54:21 -0400 Message-ID: Subject: Re: search_path wildcard? To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000007995b406190ea09d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007995b406190ea09d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, May 22, 2024 at 12:53=E2=80=AFPM David G. Johnston < david.g.johnston@gmail.com> wrote: > On Wed, May 22, 2024, 10:36 Ron Johnson wrote: > >> This doesn't work, and I've found nothing similar: >> ALTER ROLE foo SET SEARCH_PATH =3D '*'; >> > > Correct, you cannot do that. > That would be a helpful feature for administrators, when there are multiple schemas in multiple databases, on multiple servers: superusers get ALTER ROLE foo SET SEARCH_PATH =3D '*'; and they're done with it. --0000000000007995b406190ea09d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, May 22, 2024 at 12:53=E2=80=AFPM = David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, May 22, 2024, 10:36 Ron Johnson <ronljohnsonjr@gmail.com> wrote:
=
This doesn't work, and I've found nothing similar:
ALTER ROLE foo SET SEARCH_PATH=C2=A0 =3D '*';

Correct, you cannot do that.

<= div>That would be a helpful feature for administrators, when there are mult= iple schemas in multiple databases, on multiple servers: superusers get=C2= =A0ALTER ROLE foo SET SEARCH_PATH=C2= =A0 =3D '*';=C2=A0and they're done with it.
<= /div> --0000000000007995b406190ea09d--