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 1s9pFD-005NI7-KW for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 16:55:17 +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 1s9pFD-001UUD-N7 for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 16:55:15 +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 1s9pDl-001Om2-Pb for pgsql-general@lists.postgresql.org; Wed, 22 May 2024 16:53:45 +0000 Received: from mail-oo1-xc2c.google.com ([2607:f8b0:4864:20::c2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s9pDi-000EP8-8e for pgsql-general@postgresql.org; Wed, 22 May 2024 16:53:45 +0000 Received: by mail-oo1-xc2c.google.com with SMTP id 006d021491bc7-5b296194ac1so3965271eaf.2 for ; Wed, 22 May 2024 09:53:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1716396821; x=1717001621; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=8wJDISZ9GH8VgW/hy+XuZY/avoAk2Cu7mMpVwC8c+rw=; b=jvaSK7/R88UkrQkSGrAGF6tlF7bJLe0PuECJhOc2ezpdp2Q1tm1oHGCtFrg7Ih3sEi BxU4QaigVITBBCYgAfYs+NV+NpMZubu8tStn962vD47su0bns4ULck5PWGy/0Ue2/O1H 5VGvwWAAytNP50gBVCJGp3LFGXWo3k7as1Bh6PTTaU2bBDLIuHFIIldnDXtvIMgGuHeN knFIELAwrF0y+xK0f2yC2mrOci/JCRT15uX1L+59A3S6vSp0LkJ0tqBTj1AI8IREy6eX Yodls6C5t3cRAbTb8ThxyIm6U1kkQ3OP7EYtroP3EfPkoxvJ9KdU8MmzCGO2iwV2aJsg woiA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1716396821; x=1717001621; 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=8wJDISZ9GH8VgW/hy+XuZY/avoAk2Cu7mMpVwC8c+rw=; b=IvMPeUo5rNl7DU/OTCYaigeqG61ZTxPMf4AJRdQTO8Ive9NXWd/stM5OiDBIU7bTuh 60UNsmzfcZkImPlhk+Q9m6c1mI60OisdAaCTzXyQH8iibrjrvDbesbuPcdaugzPQ29J5 KxB7vtkPgdKAZn53yLT3nAMm0Xu7uYWFgc+OaecfBm69lbHeNI/LqeMVkPUJbTaIgLZg O2Q6RSApkqkxsMmD0lmTc8qowhbomSJODdIXf2ICoP7mBFOgpHlKDYWf3FgonyY8Kmys LFfGqhJp7aOyWDKV0YsKBJV5AScEc/PlxqoWPLQh5T809OAwUyWWgVAdAkzmAf4kryy3 zUmg== X-Gm-Message-State: AOJu0YzGWymCS04/Ct4EvG95Qm2ivBU0IYI+S0gLnlSfA8GvvkVzWJpD GH6vv4FtOjGBxCkWu0YdWjG4zVlWGmta//eE3S5JjOBLkEHl14+EPVtcATmiNLKwb1hj/LQs70W Qip2MGhmhliXxun01k1ccAduAtw4= X-Google-Smtp-Source: AGHT+IGFf/wwA7n4dFtSHKi41sqw1/Eox4oc21tgJfNk3MPw5yuuzVVP38jEr0NZTf0fXSVaQGDZRrtRCsOUfBQ0a4g= X-Received: by 2002:a05:6820:2218:b0:5af:36ef:27d0 with SMTP id 006d021491bc7-5b6a19003fcmr3054733eaf.1.1716396820599; Wed, 22 May 2024 09:53:40 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Wed, 22 May 2024 10:53:31 -0600 Message-ID: Subject: Re: search_path wildcard? To: Ron Johnson Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000c9184d06190dc6c8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c9184d06190dc6c8 Content-Type: text/plain; charset="UTF-8" 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 = '*'; > Correct, you cannot do that. David J. --000000000000c9184d06190dc6c8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, May 22, 2024, 10:36 Ron Johnson <ronljohnsonjr@gmail.com> wrote:
This doesn't work, a= nd I've found nothing similar:
ALTER ROLE= foo SET SEARCH_PATH=C2=A0 =3D '*';
=

Correct, you cannot do = that.

David J.
--000000000000c9184d06190dc6c8--